Now that you know how to export a CSV, you may also be interested in learning how to import a CSV. If the data is CSV data, Utilities.parseCsv(attachment.getDataAsString(), ",") is used.Below you can find detailed instructions on how to export a CSV, including images that demonstrate the process.If you want to retrieve the data from the specific sheet, please modify getSheets() to getSheetByName('#sheet name#'). In this modification, the value is retrieved from the 1st sheet of XLS data.Sheet.getRange(1, 1, csvData.length, csvData.length).setValues(csvData) Var sheet = SpreadsheetApp.openById('1ZcuTKNxa9kVSxt36UyA5cpCqGDRVK6eCTsTcz20gxWw').getSheetByName('Data') If the data is CSV, this script is used.ĬsvData = Utilities.parseCsv(attachment.getDataAsString(), ",") Var tempsheet = SpreadsheetApp.openById(tempId).getSheets() ĬsvData = tempsheet.getDataRange().getValues() ĭriveApp.getFileById(tempId).setTrashed(true) Here is the existing code for the CSV script: function importCSVFromGmail(), attachment).id I would appreciate some direction and assistance with this-thank you so much! In addition, the only sheet in that spreadsheet is also named "HBI Inventory Detail Email". The email subject is "HBI Inventory Detail" and the exact filename of the attachment is "HBI Inventory Detail Email.xls".
I have a previous google apps script (below) that will import the data from a CSV file attachment, and it works well, but all of the research and revising I have made to this script does not work correctly (and I have literally tried them all for the past two weeks). The attachment is an XLS file (Excel), and it is available in that format only. I receive a daily inventory report from my logistics provider by email. Fairly new to Google Apps Scripting here, but I am pretty good with VBA.
0 kommentar(er)
