I have already downloaded the .zip file and the first problem I hit was the different version in r-code. We are using Progress Version 9 on Linux.
A question was raised by one of our clients if it was possible to import/convert documents or comma delimited files into .xls files directly on Linux. At the moment we export the files to Windows first then open it in Excel.
I started looking around and came across the following:-
We've completed work on a conversion util to ODS, PDF, XLS, HTML (and many more formats) and a printing util. The conversion and printing utils work on both Windows and UNIX/Linux.
Does the above mean that it is really possible on Linux?
I have decided to take you up on your offer. As I have mentioned earlier on we are using Progress v9 on Redhat Linux. At the moment we output comma delimited records to a file then export the file to windows so that the user can open the file in Excel. What we want to achieve is create the Excel spreadsheet directly on Linux then subsequently export it to windows. I had a look at some of your examples and found this to be possible. Question is where do I start. In other words what must be downloaded to Linux in repect of your code?
If you'd like to convert to other files formats like PDF, HTML, Open Office, the old binary Office formats (.XLS) etc. and print directly from UNIX/Linux
download and install Open Office, it has to be at least version 3.0 but I would strongly recommend installing the latest version 3.2 (earlier versions had issues with pivot tables).
I'll be happy to call you and walk you through it later today.
Also note that we are releasing a new version in just a few days, send me your email and I'll be happy to send you a copy as soon as it's ready.
I got the application to work on Windows. I am so impressed! You mentioned it will also work on Unix/Linux? I tried this but the program libwin.p kicks out an error - 'unable to understand statement pcRootpath ... libwin.p could not understand line 538'. This error occurs when I run the program replace_pivot.p. By the way I did not unzip the files on Unix but ftp'd the files over from Windows. Surely this could not be the problem?
Incidentally when I opened the .ZIP file I could not see the 9.1d directory but when I right-clicked on it and selected 'unzip here' I could actually see it in the folder it was unzipped to. Weird hey?
Comments
#1
Please download and open the zip file.
http://www.oehive.org/files/ooxml-testdrive.zip
We are releasing a new version of the libooxml and Standard Libraries this or next week
and I would be really happy to send you a copy, if you give me your email and contact info.
By the way we also sell the source files, support and training for OpenXML and the Microsoft Office file formats.
How are you planning to use the library ?
Kind Regards
Alon Blich
+972-54-2188086
#2
BTW if anyone is interested in a one on one explanation on how to use libxlsx (at no cost)
please contact me and I'll be happy to do so.
Alon Blich
Email: alonblich@gmail.com
Phone: +972-54-2188086
#3
I have already downloaded the .zip file and the first problem I hit was the different version in r-code. We are using Progress Version 9 on Linux.
A question was raised by one of our clients if it was possible to import/convert documents or comma delimited files into .xls files directly on Linux. At the moment we export the files to Windows first then open it in Excel.
I started looking around and came across the following:-
We've completed work on a conversion util to ODS, PDF, XLS, HTML (and many more formats) and a printing util. The conversion and printing utils work on both Windows and UNIX/Linux.
Does the above mean that it is really possible on Linux?
#4
Yes you can definitely convert .CSV => .XLS and vice-versa on UNIX/Linux
We convert .XLS => .CSV on Sun Solaris all the time.
You can also convert Excel files to PDF, HTML, Open Office and a few other file formats (on any OS).
But the idea here is that you can create full, rich Excel files with 3D charts, pivots, pictures etc. on UNIX/Linux.
And do it just as easily as creating a .CSV file.
Basically just do the design in Excel and insert the data from a temp-table or query etc. in Progress on UNIX ... please have a look at the samples.
If you'd like, I'd be happy to walk you through a few samples.
Alon
#5
Alright Alon,
I have decided to take you up on your offer. As I have mentioned earlier on we are using Progress v9 on Redhat Linux. At the moment we output comma delimited records to a file then export the file to windows so that the user can open the file in Excel. What we want to achieve is create the Excel spreadsheet directly on Linux then subsequently export it to windows. I had a look at some of your examples and found this to be possible. Question is where do I start. In other words what must be downloaded to Linux in repect of your code?
Many thanks in advance.
Regards
Errol (errolc@realtime.co.za)
#6
The installation is pretty straightforward -
1. Download the Progress Standard Libraries
http://www.oehive.org/files/lib-01.01.05.zip
Extract the "lib" directory, add it to the PROPATH and compile the files.
2. Download the libooxml ZIP file
http://www.oehive.org/files/ooxml-testdrive.zip
In the ZIP file open the R-CODE directory of the PROGRESS version you have installed
and extract the "libooxml" directory and add it to the PROPATH (the files are already compiled).
That's it!
The libxlsx allows you to create Office 2007 files directly on any OS.
There's a free downloadable service pack for older versions of Office that adds support for the new formats.
http://www.microsoft.com/downloads/details.aspx?familyid=941b3470-3ae9-4...
If you'd like to convert to other files formats like PDF, HTML, Open Office, the old binary Office formats (.XLS) etc. and print directly from UNIX/Linux
download and install Open Office, it has to be at least version 3.0 but I would strongly recommend installing the latest version 3.2 (earlier versions had issues with pivot tables).
I'll be happy to call you and walk you through it later today.
Also note that we are releasing a new version in just a few days, send me your email and I'll be happy to send you a copy as soon as it's ready.
Regards
Alon
+972-54-2188086
#7
Hi Alon,
I am confused as I do not see the R-CODE directory in the ooxml-testdrive.zip file.
Regards
Errol
#8
Hi,
What is the Progress version you have installed ?
#9
Hi Alon,
The Progress version is 9.1d
Thanks for your quick response.
Errol
#10
Hi Errol,
If you open the ZIP file there is a 9.1d* directory
Inside that directory you'll find a libooxml directory.
Extract that libooxml directory out (which already comes with the .r files).
Finally add the extracted libooxml directory to your PROPATH.
Regards
Alon
#11
Hi Alon,
I got the application to work on Windows. I am so impressed! You mentioned it will also work on Unix/Linux? I tried this but the program libwin.p kicks out an error - 'unable to understand statement pcRootpath ... libwin.p could not understand line 538'. This error occurs when I run the program replace_pivot.p. By the way I did not unzip the files on Unix but ftp'd the files over from Windows. Surely this could not be the problem?
Incidentally when I opened the .ZIP file I could not see the 9.1d directory but when I right-clicked on it and selected 'unzip here' I could actually see it in the folder it was unzipped to. Weird hey?
Regards
Errol
#12
Thank you. We are also releasing a new version in just a few days!
Yes. We use the application on Sun Solaris, HP-UX and Red Hat Linux.
Please try recompiling the Standard Libraries files (the "lib" directory) on UNIX.
Feel free to contact if you have any questions.
Regards
Alon
+972-54-2188086