Search found 29 matches

by cdmmaui
Wed Dec 11, 2024 1:58 am
Forum: FiveWin for Harbour/xHarbour
Topic: Open XLS without Excel
Replies: 11
Views: 840

Re: Open XLS without Excel

I tried
oRs := FW_OpenADOExcelSheet( cSource, "Sheet1", "A1:SB65000", .T. )

And got the following errors
1. ADO ERROR UNKNOWN
2. Fail to open "XLS path + filename.XLSX"
by cdmmaui
Wed Dec 11, 2024 1:13 am
Forum: FiveWin for Harbour/xHarbour
Topic: Open XLS without Excel
Replies: 11
Views: 840

Re: Open XLS without Excel

Hola Leandro, Gracias!
by cdmmaui
Tue Dec 10, 2024 7:01 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Open XLS without Excel
Replies: 11
Views: 840

Re: Open XLS without Excel

Hi Rao,

Thank you. However, this XLS has 494 columns and about 23,000 rows. I am looking to start reading row 2 and only retrieve about 80 columns of data so I can upload to SQL. Is there a way to read data row by row like below?

cValue01 := oSheet:Cells( nCurrentXlsRow, 2 ):Value
cValue02 ...
by cdmmaui
Tue Dec 10, 2024 5:40 am
Forum: FiveWin for Harbour/xHarbour
Topic: Open XLS without Excel
Replies: 11
Views: 840

Open XLS without Excel

Hello Everyone!

Does someone have an example of how to open XLS file and read row and a certain column data? I need to run a computer (server) that does not have MS office and upload data SQL server.

Thank You!
by cdmmaui
Fri Jan 26, 2024 9:57 pm
Forum: FiveWin for Harbour/xHarbour
Topic: DateTime calculation
Replies: 6
Views: 1014

Re: DateTime calculation

Hi Rao, thank you. I had found it in xHarbour documentation
by cdmmaui
Fri Jan 26, 2024 1:57 am
Forum: FiveWin for Harbour/xHarbour
Topic: DateTime calculation
Replies: 6
Views: 1014

Re: DateTime calculation

I figured it out.
by cdmmaui
Thu Jan 25, 2024 11:40 pm
Forum: FiveWin for Harbour/xHarbour
Topic: DateTime calculation
Replies: 6
Views: 1014

DateTime calculation

Hello,

Is it possible to perform a DateTime calculation to get current time minus 10 minutes? For example

cTenMinutesBefore := DateTime() - 10

Thank you!
by cdmmaui
Tue Jan 09, 2024 12:47 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Soap Web Service - timeout request
Replies: 4
Views: 983

Re: Soap Web Service - timeout request

Hi Antonio,
Thank you. Question, if I set nSecs = 5 and responses comes back faster, will it still wait 5 seconds or process immediately?
by cdmmaui
Mon Jan 08, 2024 9:13 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Soap Web Service - timeout request
Replies: 4
Views: 983

Soap Web Service - timeout request

Hello,

It is possible to set a timeout request for a web service request? I added to IF oHttp:status=200 to check status but sometimes request hangs.

TRY
oHttp := CreateObject( 'MSXML2.XMLHTTP' )
CATCH
oHttp := CreateObject( 'Microsoft.XMLHTTP' )
END

cHttpSend := [<?xml version="1.0"?>]
cHttpSend ...
by cdmmaui
Thu Dec 14, 2023 4:00 am
Forum: FiveWin for Harbour/xHarbour
Topic: FW_OpenAdoConnection reconnect
Replies: 6
Views: 753

Re: FW_OpenAdoConnection reconnect

Thank you Rao
by cdmmaui
Wed Dec 13, 2023 10:37 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FW_OpenAdoConnection reconnect
Replies: 6
Views: 753

FW_OpenAdoConnection reconnect

Hello Everyone,

Is it possible to determine if FW_OpenAdoConnection is still alive before a FW_OpenRecordSet call and if it is NOT, is there a way to reestablish connection? Here is my sample code establishing connection.

oCn := FW_OpenAdoConnection( "MSSQL,"+xSOURCE+","+xDATABASE2+","+xUSERID ...
by cdmmaui
Fri Jul 28, 2023 4:15 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FW copy images to sharepoint
Replies: 1
Views: 499

FW copy images to sharepoint

Hello Everyone,

Does anyone have an example of how to use FW to copy images from a local folder to a folder in sharepoint?
by cdmmaui
Thu May 04, 2023 5:33 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Display jpg via http url
Replies: 5
Views: 985

Re: Display jpg via http url

Hi Antonio,

Where do I get urlmon.dll?
by cdmmaui
Thu May 04, 2023 5:32 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Display jpg via http url
Replies: 5
Views: 985

Re: Display jpg via http url

Thank you Antonio!
by cdmmaui
Thu May 04, 2023 5:19 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Http call returns image
Replies: 3
Views: 344

Http call returns image

Hello Everyone,

Can someone provide sample code that makes http request and that request returns a JPG image that I need to save on local HD?

Thank you,