function document_from_spreadsheet() {
var ss = SpreadsheetApp.getActiveSpreadsheet()
var sheet = ss.getActiveSheet()
var header_range = sheet.getRange(1,1, 1, sheet.getLastColumn())
var headers = header_range.getValues()[0]
var data_range = sheet.getRange(2,1, sheet.getLastRow(), sheet.getLastColumn())
var values = data_range.getValues()
var doc = DocumentApp.create(ss.getName() + " Exported")
var body = doc.getBody()
for (var h in headers){
h = Number(h)
var header_name = headers[ h ]
var p = body.appendParagraph(header_name)
p.setHeading( DocumentApp.ParagraphHeading.HEADING1 )
for (i = 0; i < values.length; i++){
var row = values[i]
var value = row[h]
var p = body.appendParagraph(value).setHeading( DocumentApp.ParagraphHeading.NORMAL )
body.appendHorizontalRule()
}
body.appendPageBreak()
}
doc.saveAndClose()
}
function onOpen(T) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var menuEntries = [ {name: "Export to Google Document", functionName: "document_from_spreadsheet"},
];
ss.addMenu("Admin", menuEntries);
}
#include <opencv\cv.h>
#include <opencv\highgui.h>
using namespace cv;
int main(){
Mat image;
VideoCapture cap;
cap.set(CV_CAP_PROP_FRAME_WIDTH, 640);
cap.set(CV_CAP_PROP_FRAME_HEIGHT, 480);
cap.open(0);
namedWindow("window",1);
while(1)
{
try
{
cap>>image;
imshow("window",image);
}
catch (Exception& e)
{
const char* err_msg = e.what();
std::cout << "exception caught: imshow:\n" << err_msg << std::endl;
}
waitKey(33);
}
}
The program below is for opening an image
#include <opencv\cv.h>
#include <opencv\highgui.h>
using namespace cv;
int main(int argc, char** argv)
{
IplImage* img = cvLoadImage( "image.png" ); //change the name (image.jpg) according to your Image filename.
cvNamedWindow( "Example1", CV_WINDOW_NORMAL );
cvShowImage("Example1", img);
cvWaitKey(0);
cvReleaseImage( &img );
cvDestroyWindow( "Example1" );
return 0;
}
Version 2.4.7 Additional Dependencies
opencv_core247d.lib
opencv_imgproc247d.lib
opencv_highgui247d.lib
opencv_ml247d.lib
opencv_video247d.lib
opencv_features2d247d.lib
opencv_calib3d247d.lib
function utc_approved( url ){
if (is_a_member_of( "planning-utc-controllers@york.ac.uk" ) == true ){
run_process( "Process:10", url )
set_status("UTC approved")
}else{
Browser.msgBox("Not allowed", "You need to be a member of the UTC controller group to run this", Browser.Buttons.OK_CANCEL)
}
Browser.msgBox("UTC approved" )
}
var folder_id = 'YOUR_FOLDER_ID_HERE'
var institution_folder = DocsList.getFolderById( folder_id )
var personal_folder = institution_folder.createFolder(student_name)
var template_id = 'YOUR_TEMPLATE_DOC_ID' // The Application Form
var template_doc = DocsList.getFileById(template_id)
var new_doc_id = template_doc.makeCopy("Application: " + new_doc_title).getId()
var doc = DocsList.getFileById(new_doc_id) //Move to destination folder
doc.addToFolder(personal_folder)
//Open the document for content editing
var new_doc = DocumentApp.openById( new_doc_id )
//Render the values into the doc
var s = ''
for ( var key in values) {
var value = values[key][0]
var tag = "{" + key + "}"
s+= tag + " " + values[key][0] + "\r"
new_doc.replaceText(tag, value )
}
//Replace any unreplaced tags for tidiness
new_doc.replaceText("\{.*?\}", "" )
new_doc.saveAndClose() // Force changes
var new_doc = DocumentApp.openById(new_doc_id)
var pdf_blob = doc.getAs(MimeType.PDF)
personal_folder.createFile(pdf_blob)
//Send email to student.
var text = new_doc_title + "\r\r\r"
text = text + 'Your application has been received, thank you. \r'
text = text + "\r\r\r"
MailApp.sendEmail(student_email, 'Application Received: ' + new_doc_title , text, {name: 'Automatic Script',
noReply:true,
attachments: [pdf_blob],
})
doc.setTrashed(true)//Optional...you might choose to keep it.
function doGet(e) {
var spreadsheet_id = 'YOUR_SPREADSHEET_ID'
var ss = SpreadsheetApp.openById(spreadsheet_id)
var sheet = ss.getSheetByName("Form Responses")
var last_row = sheet.getLastRow()
var last_column = sheet.getLastColumn()
var range = sheet.getRange(2, 1, last_row-1, last_column)
var data = range.getValues( )
var dataTable = Charts.newDataTable()
.addColumn(Charts.ColumnType.STRING, "Added by")
.addColumn(Charts.ColumnType.STRING, "Department")
.addColumn(Charts.ColumnType.STRING, "Researcher")
.addColumn(Charts.ColumnType.STRING, "Funder")
.addColumn(Charts.ColumnType.STRING, "Name of Call")
.addColumn(Charts.ColumnType.STRING, "URL")
for ( r in data){
var row = data[r]
var username = row[1]
var department = row[2]
var researcher_name = row[3]
var researcher_email = row[4]
var tags = row[5]
var notes = row[6]
var funder = row[7]
var name_of_call = row[8]
var deadline = row[9]
var research_title = row[10]
var folder_url = row[21]
if ( researcher_email != '' & typeof researcher_email != 'undefined' ){
researcher_name = '' + researcher_name + ''
}
folder_link = 'files'
dataTable.addRow( [username, department, researcher_name, funder, name_of_call, folder_link ])
}
dataTable.build( );
var chart = Charts.newTableChart()
.setDimensions(1200, 500)
.setDataTable(dataTable)
.setOption('allowHtml', true)
.build();
var name_of_callFilter = Charts.newStringFilter().setFilterColumnLabel("Name of Call")
.setLabelStacking(Charts.Orientation.HORIZONTAL)
.setLabel("Name of Call")
.setRealtimeTrigger(true)
.setCaseSensitive(false)
.setMatchType(Charts.MatchType.ANY)
.build()
var departmentFilter = Charts.newCategoryFilter()
.setFilterColumnLabel("Department")
.setAllowMultiple(true)
.setSortValues(true)
.setLabelStacking(Charts.Orientation.VERTICAL)
.setCaption('Department')
.setSortValues(true)
.build();
var funderFilter = Charts.newCategoryFilter()
.setFilterColumnLabel("Funder")
.setAllowMultiple(true)
.setSortValues(true)
.setLabelStacking(Charts.Orientation.VERTICAL)
.setCaption('Funder')
.setSortValues(true)
.build();
var dashboard = Charts.newDashboardPanel()
.setDataTable(dataTable)
.bind(name_of_callFilter, chart)
.bind(departmentFilter, chart)
.bind(funderFilter, chart)
.build();
var app = UiApp.createApplication().setTitle("Research")
var panel = app.createVerticalPanel().setSpacing(10)
panel.add(name_of_callFilter).add(departmentFilter).add(funderFilter).add(chart );
dashboard.add(panel)
app.add(dashboard)
var label = app.createLabel().setText("TOTAL: " + data.length + " research bid projects").setStyleAttribute("color", "#442233").setStyleAttribute("font-size", "18px")
app.add( label )
var link_to_form = app.createAnchor("Add a new Research bid", "https://LINK_TO_YOUR_FORM/viewform")
link_to_form.setStyleAttribute("color", "blue").setStyleAttribute("font-size", "18px")
app.add( link_to_form )
app.setWidth(1200)
return app
}
function onFormSubmit(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet()
var sheet = ss.getSheetByName("Form Responses")
var row = e.range.getRow()
var values = e.namedValues
var department = values['Department']
var researcher_name = values['Researcher name']
var researcher_email = values['Researcher email']
var name_of_call = values['Name of Call']
var funder = values['Funder']
var folder_title = department + " - " + researcher_name + " - " + funder + " - " + name_of_call
var destination_folder = DriveApp.getFolderById('CHANGE_TO_YOUR_FOLDER_ID')
var folder = destination_folder.createFolder(folder_title)
folder.addEditor(researcher_email)
var folder_url = folder.getUrl()
sheet.getRange( row, 22).setValue( folder_url )
}
function onEdit(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet()
var sheet = ss.getActiveSheet()
var sheet_name = sheet.getName()
var range = e.range
if ( sheet_name == 'Form Responses'){ // We're on the right sheet(s)
var row = range.getRow() // which row is being edited?
var number_of_columns = range.getLastColumn() // how wide is the sheet?
var source_range = sheet.getRange(row, 1, 1, number_of_columns) // get the row
var data = source_range.getValues()[0] // get the row's values
Logger.log( "data: " + data )
var status = data[8] // This is the cell that controls it all. The 9th item
Logger.log ( "Status: " + status )
if ( status.toLowerCase() == "ok"){
//Move the row to a "Dept: name"
var dept_name = data[3] // This is the column that controls which sheet it will go to/make
var destination_sheet = get_or_make_a_sheet( dept_name )
source_range.moveTo( destination_sheet.getRange( destination_sheet.getLastRow() + 1 , 1 ) )
destination_sheet.hideSheet() // Comment this line out if it pisses you off
// Now delete the original row from Form Responses. Eek!
sheet.deleteRow(row)
}
}
ss.setActiveSheet(sheet) // Move the user back to the orgininal sheet
}
function get_or_make_a_sheet(name){
// If a sheet is found called "Dept: name" then that is returned, otherwise a new one is created and the correct headers added.
try{
var ss = SpreadsheetApp.getActiveSpreadsheet( )
var sheets = ss.getSheets()
for ( var s in sheets){
var curr_sheet = sheets[s]
var sheet_name = curr_sheet.getName()
if ( sheet_name == "Dept: " + name ){
// A sheet with that name exists, here it is
//Logger.log( "Sheet found: " + sheet_name )
return curr_sheet
}else{
// Do nothing
//Logger.log( "Sheet: " + name + " not found")
}
}
//No sheet found with that name, so carry on and create a new one.
var sheet = ss.getActiveSheet() // Where is it being created from? The Form Responses sheet usually.
//Copy the header row
var index = Number(sheets.length) //created in the above repeat loop, maybe sheets.length would be better?
var name = "Dept: " + name
// Get main headers
var source_range = sheet.getRange(1,1, 1, sheet.getLastColumn() )
// Create a sheet but copy the headers over.
var new_sheet = ss.insertSheet(name , index)
var destination_header_range = new_sheet.getRange( 1,1,1, sheet.getLastColumn() ) // Headers go here
// Copy the headers from main sheet
source_range.copyTo(destination_header_range)
// Make it look nice, like the headers in Form Responses
var grid_id = source_range.getGridId()
source_range.copyFormatToRange(new_sheet,1,source_range.getLastColumn(),1, 1 )
return new_sheet
}catch(e){
Logger.log( e + " " + e.lineNumber + " " + e.stack )
}
}
function test_get_or_create_a_sheet(){
var sheet = get_or_make_a_sheet( "Art History")
Logger.log( sheet.getName())
}
© 2013 Klick Dev. All rights resevered.Templateism
