Activity for ABL_xls.i
-
Vincenzo Camporeale posted a comment on discussion General Discussion
Here the source code I created.
-
Hi Kurt. You have done a great job. I need to know if the library you made works well with dates. My SDO contains some date fields that are displayed in different formats in excel. In fact the dates are displayed in the format dd/mm/yyyy, or in the format mm/dd/yyyy or even in a numerical format. I am attaching a screenshot of the excel file. Thank you in advance for any help you want to give me.
-
kurt posted a comment on discussion General Discussion
Kind words. Thank you.
-
John Petersen posted a comment on discussion General Discussion
Hi, Kurt. I completely agree with you about life, it's like a runaway roller coaster. Haven't been here for a while, but wanted to thank you for making this such a powerful tool for ABL programmers to use to produce professional-looking XML from 4GL. The freezeRow() and freezeColumn() functions work perfectly.
-
freezeColumn
-
freezeRow
-
Home
-
Hey John, It's been awhile. Life has a way of getting faster as you get older. The xls.i include file has been updated with two new functions: freezeRow() and freezeColumn(). Freezing rows and columns is only supported with the XML-based spreadsheets, but that is not a problem for you. Regards, K.
-
-
Hi, Me again. I've gone through the code, but haven't found any function to freeze panes (headers). Am I missing it, or is it even possible to do that on XML creation? Thanks again for your excellent work!
-
That is correct. Download only pulls the examples. You need to pull the actual code include file from Sourceforge using Subversion (see the Code section). Sorry it has to be that way, but it makes it easier for me to manage. Regards, K.
-
JOSEPH A DROUILLARD posted a comment on discussion General Discussion
Download only sends sports.xml. Is this correct?
-
Excellent! Thank you so much, that works nicely! John.
-
Home
-
Home
-
createSheet
-
createSheet
-
createSheetWithProperties
-
createSheet
-
createSheetWithProperties
-
-
I just uploaded a new version of xls.i and updated the wiki. If you pass "FONTSIZE=20" or "FONT=Lucida Sans" (as an example) in the createCell cell_properties parameter, it'll work for both xls and xml spreadsheets. I tested it with OE11.7 and Office 365 Excel. Regards, K.
-
createCell
-
-
I really appreciate your work! Is it possible to change fonts & font size? I've looked through the includes but it appears you have to specify the entire font (family, etc). FONTSIZE= in the properties doesn't seem to do it. Thanks!
-
-
outputXML
-
outputXLS
-
Home
-
createFormula
-
inputXLS
-
inputXLS
-
inputXLS
-
inputXLS
-
inputXLS
-
inputXLS
-
inputXLS
-
createCell
-
Home
-
createCell
-
createCell
-
createCell
-
Home
-
Home
-
Home
-
createCell
-
Home
-
createCell
-
Home
-
-
ABL_xls.i released /sports.xml
-
-
-
Add initial directories
1
