Export data to OpenOffice Calc and MS Office Excel

Post by **Rathinagiri** » Wed Feb 18, 2015 2:28 pm

That is so nice of you Marek. Very useful indeed.

Of late, I am just exporting data via csv format. This will be a good solution. I think MSExcel can also open ODS formats.

Pablo César · Post by **Pablo César** » Wed Feb 18, 2015 2:31 pm

Tahnk you Marek for sharing.

I also thought very useful !

mol · Post by **mol** » Wed Feb 18, 2015 6:30 pm

Rathinagiri wrote:That is so nice of you Marek. Very useful indeed.

Of late, I am just exporting data via csv format. This will be a good solution. I think MSExcel can also open ODS formats.

New MS Excel can open .ods, of course.
But OpenOffice is free

A long time ago, our absent big friend Esgici asked me to prepare some instruction about export to excel and openoffice.
I'll prepare such a sample, but at march, I promise

Thanks for interesting!

Post by **esgici** » Wed Feb 18, 2015 7:48 pm

mol wrote: A long time ago, our absent big friend Esgici asked me to prepare some instruction about export to excel and openoffice.
I'll prepare such a sample, but at march, I promise

Thanks, speedy Gonzales

BTW I'm not absent, simply a bit quiet

Happy HMG'ing

mol · Post by **mol** » Wed Feb 18, 2015 8:45 pm

Wow, I've found solution to see some words from Esgici

too!

Post by **Rathinagiri** » Thu Feb 19, 2015 2:55 am

I am using LibreOffice from the its OpenOffice640 version. But, most of our clients still use MsExcel.

mol · Post by **mol** » Thu Feb 19, 2015 6:18 am

Export to MS Excel and format sheet is easier than in OO Calc.
I'll prepare sample for both apps.

Post by **Rathinagiri** » Thu Feb 19, 2015 6:25 am

In both the cases, the exporting system SHOULD have the respective software. That is the problem. Without connecting any OLE if we can export to Excel/Openoffice format (like PDF export), that will be great.

dragancesu · Post by **dragancesu** » Thu Feb 19, 2015 7:25 am

OLE is probably a better method of data transfer to Excel, but some do not use Excel (not free). OpenOffice is not the best documented in this work. Data transfer via the clipboard is a good solution (but no formatting)

I tried Excel and OpenOffice, Excel better recognize numbers, for OpenOffice should ALLTRIM (str(Field)) solves the problem of blanks in front of / behind the data

What bothers me in both cases, the Regional options, the problem is a sign of a decimal point, it is usually the point but what if the comma? Where to find that this is a sign? Somewhere in the Registry?

Pablo César · Post by **Pablo César** » Thu Feb 19, 2015 9:55 am

dragancesu wrote:...the problem is a sign of a decimal point, it is usually the point but what if the comma? Where to find that this is a sign? Somewhere in the Registry?

Dragan read this: http://hmgforum.com/viewtopic.php?p=34005#p34005

HMGforum.com