I doubt that anyone has done any automation with Libre-Office Calc. Most of the automation work is with Microsoft Excel as this is the dominate spreadsheet program. You can look at
as this is a VFP only class that will open a spreadsheet in XLSX format, you can then make changes, and then save. The class also allows creation of XLSX documents.
It would help if you could tell us how much you already know. Can we assume that you already know how to instantiate the automation server, open the spreadsheet and locate the cell that you want to change? Or are you starting completely from scratch?
If the former, that's a reasonable question and it's possible that someone here knows the answer. But if the latter, this isn't the place to ask. You would need to read the Libre Office documentation and make sure you understand the overall concepts involved.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.