Best way to get/send data to Open Office Calc

gharrop66 · Post by **gharrop66** » Wed Sep 30, 2015 3:59 am

Hi there,
What's the best way to get/send data from a text file to/from an Open Office Calc spreadsheet? I want something like XLGetCell XLSetCell, but those are Excel-specific. At the moment, I'm using clipboard copy-paste, but presumbably that's a slow and potentially inaccurate method.
Many thanks,
Graham.

Post by **Marcus Tettmar** » Tue Oct 06, 2015 9:29 am

Probably the way you are doing it, or sending the text (keyboard automation). There are no XL command equivalents for OpenOffice apps.

JRL · Post by **JRL** » Tue Oct 06, 2015 4:31 pm

I don't have Open Office to test but there is a connection string for it on Connectionstrings.com so maybe you could use ODBC.

gharrop66 · Post by **gharrop66** » Wed Oct 07, 2015 2:05 am

Thanks for your help. In the end, I've gone for this method..

ReadFile>newfilename,newfiledata
SetFocus>OpenOffice.org Calc*
Send>newfiledata

I was pleasantly surprised that with a vertical list of numbers in the file "newfilename", Send> puts these values into the Calc spreadsheet as separate rows of data. Just what I wanted!

Thanks again,

G.

Post by **Marcus Tettmar** » Wed Oct 07, 2015 9:36 am

Excellent

Best way to get/send data to Open Office Calc

Best way to get/send data to Open Office Calc

Re: Best way to get/send data to Open Office Calc

Re: Best way to get/send data to Open Office Calc

Re: Best way to get/send data to Open Office Calc

Re: Best way to get/send data to Open Office Calc