[Logo] Enterprise Client Community
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register /  [Login] Login 
export data  XML
Forum Index -> Development
Author Message
[Post New]18/06/2012 13:35:07
    Subject: export data
[Up]
tdrasch

Power User
[Avatar]

Joined: 13/03/2009 19:09:45
Messages: 81
Location: Villingen-Schwenningen
Offline
Hi everybody,

we are using "exporter.exportURLCsvWholeGrid" to export a Grid into a CSV - format.
The numbers have as decimal separator point ‘ . ’ instead of comma ‘ , ‘.
The problem is that in excel file some numbers like 1.131 cannot be converted to 1,131.
Has anyone an idea to convert in excel or to change the export function?

regards
Thomas
--------------------------------
Good karma - for the moment...
why is the word abbreviation so long?
[WWW]
[Post New]18/06/2012 13:44:31
    Subject: Re:export data
[Up]
CaptainCasa

Power User
[Avatar]

Joined: 21/11/2007 12:23:06
Messages: 5523
Offline
Hi,
if you add Apache POI to the server side libraries (WEB-INF/lib) then a direct Excel export becomes available. In this export data types are (should be) properly treated.
Regards, Björn
Björn Müller, CaptainCasa GmbH
[Post New]18/06/2012 13:58:09
    Subject: Re:export data
[Up]
dstrigel

Power User

Joined: 09/12/2010 09:23:42
Messages: 69
Offline
you can configure the Excel import. Hope my screenshot will explain it. Use Dezimaltrennzeichen "."

Regards
Daniel
[Thumb - csv_import.png]
 Filename csv_import.png [Disk] Download
 Description
 Filesize 91 Kbytes
 Downloaded:  309 time(s)

 
Forum Index -> Development
Go to:   
Powered by JForum 2.1.6 © JForum Team