FiveTech Software tech support forums

... and also saving the changes (to another xlsx file) without Excel or ACE OLEDB installed on the PC.

Simple Usage:
FW_ShowXLSX( cFileXlsx, [cSheet] ) // --> oXlsx object

Examples:
FW_ShowXLSX( "customer.xlsx" )
https://imagizer.imageshack.com/v2/xq70/922/4TnfrA.png

FW_ShowXLSX ...

... when we have to request material we have to request it from different suppliers, when I have the suppliers' estimates I use Excel and in each sheet I insert the order-type estimates for each supplier. each supplier must create a quote for the same material.

I therefore thought of converting ...

Hi Antonio,
I just want to check code snippets on how to add new sheet in Excel and how to select a sheet based on name or number

... and yOffset to 120,150 because I use the HP laserjet printer
you imagine that if my program is used in another school
with another printer that I don't know the parameters are wrong and the print comes off the sheet
I can't have any worries like that, the program should always work the same way

Marco,
with the tprinter class it is easy to calculate the number of pages, just set how many rows you want per sheet and then divide the total archive with the rows and you will have the number of pages, but with the treport class I cannot do it, that is, it is displayed to me the page number but not ...

when double on rpreview not make zoom and I have this error





before if I double clicked on the sheet the preview showed the zoomed page and you couldn't even see the lupa cursor

This example demonstrates:

1. Image Brush
2. Sheet name customized
3. Group Headers
4. Freeze Header Rows
5. Hide Zero values
6. Footer row with aggregage formulae

https://imagizer.imageshack.com/v2/xq70/923/CY8dZk.png

Exporting tables is very simple
#include "fivewin.ch"

function Main ...

hi,
I am not able to write or read images to/from excel files using ADO.
Is it possible?
have not try ADO Type adTypeBinary yet

---

have found Sample which "read"
objStream := CreateObject( "ADODB.Stream" )
objStream:Open()
objStream:Type := 1 //adTypeBinary
objStream:LoadFromFile( cFile ...

hi,

do you have a Sample how to "insert" Image into Excel Sheet using DrXlsx LIB :?:

/* Insert an image. */
worksheet_insert_image( worksheet, 1, 2, "hb_logo.png" )

/* Insert an image with options. */
options := {"x_scale" => .5, "y_scale" => .5 }
worksheet_insert_image_opt( worksheet, CELL ...

I am not able to write or read images to/from excel files using ADO.
Is it possible?

YES this "seems" to work, no Error in LOG :D

but when try to open Excel Sheet i got Warning and all Type "C" are empty ... :shock:



This is the test I made.
#include "fivewin.ch"

function Main()

local cOemHex := "8494818E999AE1"
local cOemText, c, oXlsx
local cFileXls := "UMLDRXL.XLSX ...

... fieldGet( n ) ) ) )
Please use UML_OEMTOANSI() but not OemToAnsi()
YES this "seems" to work, no Error in LOG :D

but when try to open Excel Sheet i got Warning and all Type "C" are empty ... :shock:

---

i have compare
cText := UTF16toUTF8( strToWide( UML_OEMTOANSI( cText ) ) )
vs ...

i like to get a working Excel Sheet with German "Umlaute" using DrXlsx

Suggested:
OEM -> ANSI -> UTF8
For ansi to utf8 So we can use: Please use UML_OEMTOANSI() but not OemToAnsi()

... T. )
USE (cDBF) // CODEPAGE cCodepage EXCLUSIVE
now please try to "export" to Excel using DrXlsx, NOT XBROWSE

i like to get a working Excel Sheet with German "Umlaute" using DrXlsx

---

when you ask me for STRTOHEX() i got
xValue = "„" STRTOHEX(xValue) = "84" ASC(xValue) = 132
xValue ...

... thx

it is a "normal" that RAM is "limited" for 32 Bit App
i have "hope" it does "write" when have "read" but all seems to go to RAM

when it "crash" there is no XLSx, you need to "close" to "write" Excel Sheet

Question : is it possible to use a Thread to "write" what have been "read" before :?: