SRL Archive - OSR Help

Exporting data to a google spreadsheet?


Always

2012-02-26 21:49:20

Is there a way that a script would be able to export data to a google spreadsheet? Basically I'm looking to try to make a script that would buy items and record the market price on the google spreadsheet, would update the prices every 30 minutes or so.

Thanks

Brandon

2012-02-26 22:04:56

You'd need to know how the Spreadsheets are made.. Do they use nodes like XML files? What format do the files use?
Do they open in binary mode? Are they encrypted or obfuscated it in anyway?

LordJashin

2012-02-26 22:53:52

From: Always
Is there a way that a script would be able to export data to a google spreadsheet? Basically I'm looking to try to make a script that would buy items and record the market price on the google spreadsheet, would update the prices every 30 minutes or so.

Thanks


If you could type the layout for a spreadsheet file in notepad you could do this. You'd create the file in whatever spreadsheet file format then write to it the Variables your stock stuff is stored in. Better yet I think there are some programs that can convert to spreadsheet. Google .xls or .format to .format converter. So in this case .txt to .xls or whatever spreadsheet format converter.

Then after your done typing in the file it will be in your spreadsheet format and you should be able to open it with w/e spreadsheet program

Be much easier to just do all of it in a text file.

Er1k

2012-02-27 02:26:04

Spreadsheet might be a bit far, maybe begin with a CSV file and open that as excel?