Page 1 of 1

[Solved] Macro to read data from xlsx and write to ods

PostPosted: Thu Jun 06, 2019 6:37 pm
by croko
Later edit: Thanks guys, I did it myself after learing from other posts on this forum.

I have an excel Source.xlsx file with text and number data.

I want to open the excel file with the last version of OpenOffice (4.1.4) and run a macro in OpenOffice Calc that will take the data from my excel file and put in a new OpenOffice Spreadsheet file (.ods format).

This mean that the macro should run in OpenOffice Calc and create a new .ods file and populate it with data from the excel file I have open in OpenOffice Calc when I run the macro.

Attached is the detailed brief with an an example of the excel source file and the OpenOffice Calc destination file. Please note the password for the Destination.ods file is: test111

Re: I pay for macro to read data from xlsx and write it to o

PostPosted: Thu Jun 06, 2019 8:44 pm
by RusselB
last version of OpenOffice (4.1.4)
This is no longer correct. The latest release of OpenOffice is 4.1.6

As you are wanting to take information from a .xlsx file and put it into a .ods file, rather than use a macro, have you considered using LibreOffice
LibreOffice has a higher level of compatibility with the later Microsoft versions (eg: .xlsx rather than .xls)

Re: I pay for macro to read data from xlsx and write it to o

PostPosted: Fri Jun 07, 2019 8:40 am
by croko
RusselB wrote:have you considered using LibreOffice

Thanks for the recommendation, now I switch to LibreOffice.
But I still need to use a macro in order to automate the process because the real source file have thousands of rows.

Re: I pay for macro to read data from xlsx and write it to o

PostPosted: Fri Jun 07, 2019 9:54 am
by robleyd
Seems this is much more complex than simply converting xlsx to ods; there is an amount of processing and formatting specified.

Re: I pay for macro to read data from xlsx and write it to o

PostPosted: Fri Jun 07, 2019 9:57 am
by RoryOF
If this is a one off application it might be worth trying a conversion service such as http://www.zamzar.com

Re: I pay for macro to read data from xlsx and write it to o

PostPosted: Fri Jun 07, 2019 5:18 pm
by RusselB
Zamzar might be an acceptable option, even if this is gping to be something on going.
The first limitation I can see is the size of the .xlsx file that Zamzar would be working with.
There are file size limits for all but the highest paid accounts.