Hi Siva,
If you are fetching patients from a database, you may use this API: Automatic
Report Generator
|
| |
Automatic Report Generator
Download Automatic Report Generator for free. Generate reports from Java
applications directly. Generally, what ... | |
|
Merci,
Mohamed Ennahdi El Idrissi
mohalgorithmsorbit.blogspot.com
From: Siva Sripada <sivaksrip...@gmail.com>
To: David Law <david....@apconsult.de>
Cc: POI Users List <user@poi.apache.org>
Sent: Monday, April 24, 2017 9:46 AM
Subject: Re: Java API for Excel
Hello
In fact this is the route I've taken. I'm using the OpenCSV API. Thanks for
your reply and help tho!
Siva
Sent from my iPhone
> On Apr 23, 2017, at 11:04 AM, David Law <david....@apconsult.de> wrote:
>
> Hi,
>
> one thing was not quite clear about the original question:
> do you actually need the Excel at all?
> or is the sole purpose of the exercise just to generate a CSV-File for your
> upload?
>
> And even if you do need the Excel, it would seem easier just to change the
> Programme to write the CSV as a second file without having to use POI for
> that bit.
>
> Surely, the Excel CSV-Format is just a question of using other delimiters
> between fields?
> (and maybe quoting/escaping any strings containing delimiters, which is
> absolutely trivial)
>
> All the best,
> DaveLaw
>
>
>> On 21/04/2017 20:04, Dominik Stadler wrote:
>> Hi,
>>
>> Can you share an anonymized sample-csv-file? Apache POI likely does not
>> have support for this itself, but if it is a text-format, it should be
>> fairly easy to iterate over the rows/cells and produce the text-format
>> yourself if we can figure out how Excel formats this CSV in some special
>> way to be able to later detect the format again.
>>
>> BTW, please post such questions to the user-list, not to developers
>> directly, this prevents others from participating in the documentation.
>>
>> Dominik.
>>
>> On Fri, Apr 21, 2017 at 7:45 PM, Siva Sripada <sivaksrip...@gmail.com>
>> wrote:
>>
>>> Hi,
>>> My name is Siva Sripada and I am a physician living in Michigan. I am
>>> writing a program to upload a list of patients (first name, last name,
>>> birthdate) to a website that will provide me information on a patient’s
>>> previous prescription history over the last 1 year.
>>> I am using the Apache API for Java for Excel and the program works
>>> great!!! but….The website requires that the file be in *Excel’s* CSV format
>>> only. So for example the website will not take a text file with
>>> comma delimiters saved as a CSV file. Nor will it accept a .xlsx that was
>>> simply renamed with a .cvs file. Currently I am opening the .xlsx file
>>> saved with my program thru Excel and re-saving it with Excel’s CSV format
>>> - which works but does not leave me satisfied.
>>>
>>> Excel’s CSV files have the unique(?) property of being able to be opened
>>> by both Excel and any text editor (don’t know if that means anything to
>>> you). Plus these files when opened in a text editor have comma delimiters
>>> plus a carriage return at the end of each line.
>>>
>>> My question is :
>>> Is there a way to change the formatting of the .xlsx file thru The Apache
>>> API so that it saves it as a “true” Excel CVS file?
>>>
>>> Any help would be appreciated.
>>> Thank you,
>>> Siva Sripada
>>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
