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"
Search found 29 matches
- Wed Dec 11, 2024 1:58 am
- Forum: FiveWin for Harbour/xHarbour
- Topic: Open XLS without Excel
- Replies: 11
- Views: 840
- 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!
- 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 ...
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 ...
- 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!
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!
- 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
- 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.
- 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!
Is it possible to perform a DateTime calculation to get current time minus 10 minutes? For example
cTenMinutesBefore := DateTime() - 10
Thank you!
- 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?
Thank you. Question, if I set nSecs = 5 and responses comes back faster, will it still wait 5 seconds or process immediately?
- 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 ...
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 ...
- 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
- 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 ...
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 ...
- 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?
Does anyone have an example of how to use FW to copy images from a local folder to a folder in sharepoint?
- 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?
Where do I get urlmon.dll?
- 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!
- 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,
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,