Search found 383 matches: sheet

Return to advanced search

Re: Fivewin Wiki

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
by hua
Sun Mar 17, 2024 8:05 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Fivewin Wiki
Replies: 9
Views: 509

Re: nYoffset and nXoffset

... 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
by Silvio.Falconi
Mon Jan 15, 2024 11:04 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: nYoffset and nXoffset
Replies: 11
Views: 744

Re: Calculate total pages

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 ...
by Silvio.Falconi
Thu Nov 23, 2023 4:04 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Calculate total pages
Replies: 32
Views: 5508

Fwh 23.10 rpreview problems

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

Image



before if I double clicked on the sheet the preview showed the zoomed page and you couldn't even see the lupa cursor
by Silvio.Falconi
Wed Nov 08, 2023 10:07 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Fwh 23.10 rpreview problems
Replies: 7
Views: 429

Re: Xlsxlibhb_ver2

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 ...
by nageswaragunupudi
Thu Oct 19, 2023 4:04 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Xlsxlibhb_ver2
Replies: 57
Views: 8404

Re: DBF to Excel Sheet, without Excel, using ADO ?

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   //adTypeBina...
by Jimmy
Mon Sep 04, 2023 9:31 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2321

Re: Announcing DrXlsx 1.0 by Charles Kwon

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" ...
by Jimmy
Mon Sep 04, 2023 9:27 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Announcing DrXlsx 1.0 by Charles Kwon
Replies: 32
Views: 3510

Re: DBF to Excel Sheet, without Excel, using ADO ?

I am not able to write or read images to/from excel files using ADO.
Is it possible?
by nageswaragunupudi
Sun Sep 03, 2023 9:39 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2321

Re: not ISOEM(), ISANSI() or IsUTF8()

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"  ...
by nageswaragunupudi
Wed Aug 30, 2023 2:23 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: not ISOEM(), ISANSI() or IsUTF8()
Replies: 34
Views: 1927

Re: not ISOEM(), ISANSI() or IsUTF8()

... ) ) ) 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( ...
by Jimmy
Wed Aug 30, 2023 8:35 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: not ISOEM(), ISANSI() or IsUTF8()
Replies: 34
Views: 1927

Re: not ISOEM(), ISANSI() or IsUTF8()

i like to get a working Excel Sheet with German "Umlaute" using DrXlsx Suggested: OEM -> ANSI -> UTF8 For ansi to utf8 UTF16toUTF8( strToWide( cAnsi ) ) So we can use: UTF16toUTF8( strToWide( UML_OEMTOANSI( ...
by nageswaragunupudi
Wed Aug 30, 2023 7:29 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: not ISOEM(), ISANSI() or IsUTF8()
Replies: 34
Views: 1927

Re: not ISOEM(), ISANSI() or IsUTF8()

...  // 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" ...
by Jimmy
Wed Aug 30, 2023 6:08 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: not ISOEM(), ISANSI() or IsUTF8()
Replies: 34
Views: 1927

Re: Announcing DrXlsx 1.0 by Charles Kwon

... "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 :?:
by Jimmy
Mon Aug 28, 2023 1:16 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Announcing DrXlsx 1.0 by Charles Kwon
Replies: 32
Views: 3510

Re: DBF to Excel Sheet, without Excel, using ADO ?

hi, You keep pointing out as if it is a defect with FWH functions. i do not say it is a "Defect" but it is missing so that Fivewin Function can NOT work with Excel "this Way" yet when debug CODE i saw often that "cDbms" is empty so it can not get Value and use "def...
by Jimmy
Thu Aug 17, 2023 1:21 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2321

Re: DBF to Excel Sheet, without Excel, using ADO ?

hi, While creating Excel Table, ADOX can not create more than 7 fields at a stretch and the field MARRIED is the 8th field. where do you read it about 7st Element :?: as i can say your CODE is wrong. you need a "fresh" ADOC.Column for every Column :!: FUNCTION FW_ADOX_CreateExcelTable(...
by Jimmy
Thu Aug 17, 2023 12:50 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2321
Next

Return to advanced search