Export of Data to Excel?

Hi all,

Is it possible to export data (not the report itself) straight to Excel, rather than going through the intermediary step of CSV?

Going to CSV causes problems:
1. We have a string that has leading zeros, and Excel naturally chops those off in CSV format.
2. Excel also converts strings that appear to be dates, even if they are not.

My ultimate goal is to export to excel, maintaining the column data types.

Does anyone have any experiences or suggestions on the matter?

Justin

Find more posts tagged with

Comments

mwilliams

Hi Justin, 
 
So, you are using the standard XLS output for BIRT and this is happening? 
 
Have you tried the Tribix XLS emitter? 
 
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/33-tribix-extended-emitters-for-birt/#description'>Tribix - Extended Emitters for BIRT - Designs & Code - BIRT Exchange</a>

Suri

The issue of Excel removing leading zeros of my fields that are strings is happening to me too, when I export to XLS via tribix emitter 2.3.
I´m using BIRT 2.3.2.

I need those "zeros"! :-)

Any ideas?

Regards,
Suri

jpoma

<blockquote class='ipsBlockquote' data-author="mwilliams">Hi Justin, 
 
So, you are using the standard XLS output for BIRT and this is happening? 
 
Have you tried the Tribix XLS emitter? 
 
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/33-tribix-extended-emitters-for-birt/#description'>Tribix - Extended Emitters for BIRT - Designs & Code - BIRT Exchange</a></blockquote>
 
I am not using the XLS output for birt, but using the data export function that only has the CSV export option. I am looking for exporting data directly to excel.

mwilliams

Justin,

I see now. I don't think there's gonna be a way to do this out of the box.