I have an Excel Spreadsheet that gets re-created twice a day called "Daily Report" It is always in the same folder location.
Using a SQL Server Integration Services Script (C#) to automate this process, I need to completely overwrite the "Daily Report" tab in a Google Spreadsheet called "Company Info" that has about seven other tabs. The ENTIRE Excel file has to overwrite the Daily Report tab in the Google spreadsheet, including all formatting seen in the Excel file. I know how to upload data, but that isn't what is needed here. I don't just need data, I need all the formatting in the Excel sheet to be seen in the Daily Report tab of the Company Info spreadsheet. I have a process that will upload the Excel file to a single-tab Google Sheet called "Daily Report" as often as necessary from the Excel file, but I can't figure out how to automate the process of getting that single tab (Daily Report) into the larger "Company Info" spreadsheet. The process I have only overwrites an entire spreadsheet, not a single tab. I Perhaps someone can guide me a bit here I was thinking I could create a C# script that calls the Google API from within SSIS to do the following: Use an API call to Delete the original Daily Report tab in the Company Info Spreadsheet. Copy the Daily Report tab from the Daily Report spreadsheet into the Company Info spreadsheet by using the API to "Copy to' Rename the "Copy of Daily Report" sheet to "Daily Report" in the Company Info spreadsheet. Does that all make sense? Isn't there some easier way of doing this? Please help. I really am a complete novice at using the Google API, so I'm clueless about the syntax. -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
