Friday, 13 September 2013

Need Advice! Use .csv data in a spreadsheet directly from a local drive

Need Advice! Use .csv data in a spreadsheet directly from a local drive

I'm trying to write a script to directly upload data from a .csv file
stored on a local hard drive to a google spreadsheet without placing the
.csv into the google docs list.
I realize that google spreadsheets already has a function for doing this,
but my end game here is to be able to upload data daily from a .csv on a
local drive, to my script, sort through it, and return only the necessary
information to a spreadsheet.
Currently I'm trying to test my readDSR (should be reading the uploaded
.csv)function by returning the .csv data as a string in my spreadsheet.
However it won't work. I would really appreciate some help on this one. My
code is below
Thanks, -Jamie
function onOpen() {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
var entries =
[ {name:"Read Data", functionName:"readRows"},
{name:"Upload DSR", functionName:"findDSR()"} ];
sheet.addMenu("Du-par's", entries);
};
function findDSR() {
var openFile = UiApp.createApplication();
var formContent = openFile.createVerticalPanel();
formContent.add(openFile.createFileUpload().setName("DSRfile"));
formContent.add(openFile.createSubmitButton("Start Upload"));
var form = openFile.createFormPanel();
form.add(formContent);
openFile.add(form);
SpreadsheetApp.getActiveSpreadsheet().show(openFile);
}
function readDSR(e) {
DSR = e.parameter.DSRfile;
csvFile = DSR.getContentAsString();
var sheet = getActiveSheet();
var lastRow = sheet.getLastRow()+1;
var lastCell = sheet.getLastCell("A"+lastRow);
lastCell.setValue = csvFile;
}
}

No comments:

Post a Comment