... are only 3 users and would like to work on 6 pc's A FWH invoice / Items dbf's related program will be the program to serve. Each user has his own exel, mail, etc. I have no intension on putting these programs on the server. Just that 1 FWh program. Maybe some more items are put on the server, ...
I'm running my program under RD but I need to create a excel file. On the server there is no exel installed. I can instal it but it seems that a other kind of lincence is needed for excel to install on a server Windows 2019
... but is not the best. I see in Xbrowse the different name items. If I click on the value a second browse is opened. This brouwse I can save to exel from xbrowse and this I do for all the groups. a group = the "name" in browse Kleur Maten Kleur_D Kleur_L .... Each could be a seperate ...
Xbrowse has several options to export data (dbf/csv/exel) but how to put them into a array in memory ? xbrowser ( hData[ "data" ] ) COLUMNS "productid", "model" setup ( oBrw:cHeaders := {"productid","model"}, ...
... dozens of xls regualar, I once match the fields with the headers in a xbrowse, make the dbf and read it. also as third... Read the first line of exel with OLE, changes the headers into the xls and save it. Then use exeltodbf function to generate the dbf If needed one of these, I have some basic ...
... dbf. (physicalquantity, minimum, .....) The dbf would have than ALL the fields insite. Now the complex data stay blank (at least tested Xbrowse to exell) That way we would let xbrowse do the hard work :D :D :wink: (I do it for exel files...)
Using this code : @ 880,400 BTNBMP oBtn1 OF oDlg SIZE 200, 30 NOBORDER PROMPT "Prijswijzigingen naar Exel" 2007 TOOLTIP "Tool1" ACTION exportdata(obrw4) function exportdata(oBrw) select nofoto set filter to nofoto->selected oBrw:refresh() ...
... that I'm on the wrong route here .... I can't change the data of oRange, because oRange has allready all the data when getexcelrange = used In exel I have Code -> become into oRange 511.53.00 511.53.00 // ok 300346 300346.00 // nok 400 400.00 // nok My idea was that at the moment of reading ...
... I tried most things I found, but the numbers stay numbers.... Can someone please use this simple function and see if the numbers in the opened exel are shown as char values by the browse ? In my case all numbers have a .00 added and that is a problem for the colomns that are used as reference ...
Thanks Rick, The code looks ok, (to be done for my level) I will convert van exel to dbf in my case FW_Exeltodbf will convert numbers to numbers, but there are times that numbers are (product codes) and need to be Char. With OLE and functions like Set( "NumberFormat", ...
It seems that i ran into some limitations using the FW_ExcelToDBF function adn that I better move to TOle with exel
Is there a sample that opens a exel, and copy all koloms into a dbf ? In that situation I can change the values from the source exel to ALL text values. with the OLE function i think.
oRange := GetExcelRange( cCurfile , NIL ) Is it possible to enhance this function to be able to convert the exel data the way we want it at time of reading the file ? As we know, if the exel file has nummes, it will put a extra .00 behind it. For really number (prices, ...) this ...