Project information Project: libxlsx

Project:libxlsx
Component:Code
Category:feature request
Priority:normal
Assigned:Unassigned
Status:active
Description

i just download and unzip testdrive for libxlsx and set propath then run the replace_chart.p but it does not produce any error but there is no output in sample replace_chart.xls , so can u explain how to install and how we pass parameter for , it is better to make some document so that one can easy to understand the code and upgrade. Thanks.


Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
alonb's picture

#1

Title:Project information Project: libxlsx » Project information Project: libxlsx

Did you install the latest version of The Progress Standard Libraries ?

And if you so what version are you using ?


#2

yes , I have installed the latest version of Progress Standard Libraries and i am working on Progress 10.2A. i also want to know that this code can generate .ods file directly or not.


alonb's picture

#3

There is no OpenEdge 10.2a r-code in the testdrive version zip file. I will upload one today.

Do you have an installation of Progress version 9.1, 10.0 or 10.1 you can try libxlsx.p on ?

libxlsx.p uses OpenOffice for printing and document conversion.

Using OpenOffice for document conversion is very common. Google - JODConverter and Drupal.

I'd be interested to know more on how and where you'd like to use libxlsx.p ?

And if you'd be interested in a libdocx.p library ?


#4

Currently i use two methods of creating Spreadsheet reports (Excel via OLE, and XMLSS) but both methods are limited and don't provide a good future proof solution, So I am searching for progress stuff that create Report OpendDoc format(ODF) so i can view on any platform. Yes I am interested in a libdocx.p and I am trying to test-drive with libxlsx.p so how long i can walk with it.


alonb's picture

#5

libxlsx.p test drive doesn't have time limitations you just can't use it in a production environment.

about libdocx.p if someone actually buys a copy of libxlsx.p i might think of completing libdocx.p.

we've lost enough time+money on libxlsx.p at the moment. so i'm not sure that will happen soon.


#6

HI Alonb,
Can you Explain me why Error Message "Document conversion for ..\replace_char.xlsx" to ...\replace_chart.pdf " unsupported.(ooxml_conversion_unsupported)" is generated while run convert_print.p since replace_char.xlsx is same that were in the Samples.


alonb's picture

#7

libxlsx.p uses external utils like openoffice, msoffice etc. for printing and document conversion.

rendering full office documents with graphs, charts, pivots etc. is a little bit out of the scope of this project.
it will be like recreating office.

at the moment libxlsx.p supports openoffce 3 and higher.

i started work on support for msoffice, and novell's opensource doc converter
but i stopped since no one was using libxlsx.p.

bottom line is libxlsx.p only supports the document types these utils do
and since no utils are installed no document types are supported (i'll change the error message, though).

download and install openoffice 3.1
if needed, change the &preprocessor ooxml_xOpenOfficeDir in the libooxmlprops.i file to the openoffice installation directory (don't worry you won't need to recompile).

thanks for downloading it is really encouraging. hth