FiveTech Software tech support forums

... oRange Give me first this Message "ADO ERROR UKNOWN" and then "fail to open "C:\work\errori\getexelrange\orario.xls" I think I must install Microsoft.ACE.OLEDB from https://www.microsoft.com/it-it/download/details.aspx?id=13255 another ...

nageswaragunupudi wrote:GetExcelRange() can not open xls file, if it is already opened by any application other than Microsoft Excel.
Close Google Sheets and try.
Also give full path.

please I not open the xls file with another app
please do you see my test sample ?
the file orario.xlsx is on the root of exe

... .... @ 2.3, 2 FOLDER oFld PIXEL ADJUST ; ITEMS "&Dati della scuola","Parametri Generali",; "Calcolo","Orario delle lezioni","Ore per giorno","Assenze"; SIZE 235,190 oFld:nOption:=nscelta there is a method to enable the others ...

Conversion from xls to temporaney dbf made ok (thanks Rao) Conversion from temporaney dbf to my orario.dbf made ok ( thanks Cristobal for hb_aTokens) the procedure save on teacher archive, in classroom archive, in room archive and on orario.dbf the last problem is that ...

... ok First I must converte Xls into tabella.dbf and it is ok ( I fogot to set the same field on xls and dbf) then I must converte tabella.dbf into Orario.dbf ( to hand) because I must insert before the name of the teacher and save on Docenti.dbf , It must return the number of Record this number ...

Now I resolve to converte Orario.xls to My dbf ( but I made only the first step) the error is as Nages sad me "...Please make sure the datatypes of Excel columns and FieldTypes of the DBF match." I rename all Excel colums https://s8.postimg.cc/koqg0n00l/ok_dbf.png ...

using the NagesRao note I found on this forum I created this test It create Tabella.dbf and then call Orario.xls and converte it on dbf #include "fivewin.ch"#include "ord.ch"#include "dtpicker.ch"REQUEST HB_Lang_ITREQUEST HB_CODEPAGE_ITWINREQUEST ...

Silvio,
the printout should be exactly like "tabellone orario settimanale". Is this right.

Best regards,
Otto

Application =========== Path and name: C:\Documents and Settings\Administrator\Desktop\Orario\Main.Exe (32 bits) Size: 6,509,568 bytes Compiler version: xHarbour 1.2.3 Intl. (SimpLex) (Build 20140725) FiveWin Version: FWHX 15.01 Windows version: 5.1, Build 2600 Service ...

Mr Rao, If I wish create ( to hand) the report how I can make to call the values of headers and subheaders of a xbrowse ? I use the xbrowse with an array to understands my problem do you Remeber the school software ? http://www.eoeo.it/wp-content/uploads/2015/05/orario_stampa.jpg

Imade some thing on Orario application

nora:=alltrim(str(oBrw:nRowSel))
ngiorno:=alltrim(str(oBrw:nColSel-1))
oBrw:SelectedCol():Value := OR->CLASSE

I not Know how print this xbrowse but I have hard problems http://www.eoeo.it/wp-content/uploads/2015/05/orario_stampa.jpg 1. the report not see if there are multiheaders 2 if I converte it on Excel or Openoffice Calc not print the multiheader 3. I'd like to exclude the last 3 column...

... aDatiDisp[10,6,4,9] I save on this array 10= hours from 1 to 10 6= number of days from monday to saturday 4= type of show 9= number of fields of Orario.dbf if (!Empty(orario->gg_ora)) Do while ! orario->(eof()) n_giorno:=Val(Left(orario->gg_ora, 1)) n_ora=iif(Val(right(orario->gg_ora, ...

... come il $$1? Per quanto riguarda DO->oredispo, se sicuro che sia un CHAR? In questo passaggio, l'alias OR punta proprio al file originale ORARIO? Non magari ad un file temporaneo dove il campo è ora numerico? Proprio in questi giorni sto facendo una conversione di un programma da Clipper ...

... docenti è l'archivio stravecchio del 1992 . C'è una procedura che si chiama Ciclone che apre gli archivi, li azzera cioè azzera alcuni campi di orario ( gg_ora se non trova un carattere nel campo Blocco) , classi ed aule ( campo ore_ass cioè le ore assegnate). Da questa funzione si arriva in ...