Hi Ramesh, There are a couple of approaches:
1) You could use the Documents API to import the sheets you need to convert. This will create a new spreadsheet, but you can delete it after you have finished. This approach spares you from having to parse the CSV and XLS sheets yourself. You then either: b) use the Google Apps Script API's SpreadsheetApp.openById() method to open the temporary and target sheets and copy values on the server side; a) use the Spreadsheets List API copy values from the temporary spreadsheet to your target spreadsheet - this involves more network I/O than 1a. 2) You could parse the CSV and XLS worksheets 'locally', and use the Spreadsheets List API to push the values to the target spreadsheet. cheers, David. Xref: Documents API - http://code.google.com/apis/documents/ Spreadsheets List API - http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#ListFeeds Google Apps Script API for Spreadsheets - http://code.google.com/googleapps/appsscript/class_spreadsheetapp.html On Mon, Apr 25, 2011 at 1:33 AM, Ramesh V <[email protected]> wrote: > Hi All, > I am new to Spread Sheets development. I am in a need to convert excel and > csv files to spread sheets. > Converting means i should not create a new spread sheet, i need to copy > these files data to an existing spread sheet. > Please let me know in case you need more details. > > Thanks, > Ramesh.V >
