conversion of data for filePro?

[Richard D. Williams]

On 9/21/2012 3:11 AM, Fairlight wrote:
> On Thu, Sep 20, 2012 at 08:06:47PM -0500, Bob thus spoke:
>> Mark,
>>
>> Just go to Save As and select the csv file time.  Works like a champ
>> and ready for filepro import.
> It seems like it's a banner day for people forgetting that not all data
> originates locally.
>
> A third party would be supplying XLS files.  The systems running filePro
> won't have Excel - they're linux boxen.  The side running filePro won't
> have any control over what's sent.
>
> So...  We're looking at a need to do this unattended, on linux.
>
> We have a lead on one potential solution (perl's "xls2csv" project).  We
> wanted to see what other solutions might have been used to excellent
> success, however.
>
> mark->
Mark,

Try php.

read excel
http://sourceforge.net/projects/phpexcelreader/

write to excel
http://www.stargeek.com/php_scripts.php?script=2&PHPSESSID=0b30b0d778ecedc806d38b92bb158097

Richard