FiveTech Software tech support forums

... the current, but in a previous column from the current one a EJECT will be done automatically At the end of this class is a little function call WorkSheet that will make the job of DOS printing a lot easier. Enjoy it! ******************************************************************************** ...

Hi, aa_chn.dbf is a dbf table that contains in des_chn field some chinese characters If a create an excel worksheet and write into cell the "des_chn" field content they does not appear as in the dbf field http://www.marcoboschi.it/public/cattura.jpg ...

Hi to all! You know what? The funniest thing is: SILVIO´S ROUTINE DOES WORK! Only have to put the right xls and worksheet names. Thanks for the info! It is an excellent general purpose routine. ;-) Euclides http://forums.fivetechsupport.com/viewtopic.php?f=3&t=31574 IMPORTANTE ...

Hi to all!
You know what? The funniest thing is: SILVIO´S ROUTINE DOES WORK!
Only have to put the right xls and worksheet names.
Thanks for the info!
It is an excellent general purpose routine.
Euclides

... Error occurred at: 21/07/2015, 18:50:22 Error description: (DOS Error -2147352567) WINOLE/1007 No se puede obtener la propiedad Paste de la clase Worksheet. (0x800A03EC): Microsoft Office Excel Stack Calls =========== Called from: => TOLEAUTO:PASTE( 0 ) Called from: c:\fwh\source\classes\xbrowse.prg ...

Prueba a poner como paramentro de :WorkSheets( "Nombre de Hoja" ), o :ActiveSheet() en lugar de WorkSheet
También tienes informacion en
viewtopic.php?f=3&t=20763&p=110344&hilit=WORKSHEETS#p110344

... error's meaning is that oSheet:Cells( nRow, nCol ) is NIL, where as it should be a range object. If for some reason oSheet itself is not a valid worksheet object we should get error that oSheet does not have method Cells. Though I am not sure xharbour can be so precise about reporting this kind ...

...           Row = 1           Column = 1           While (user <> "")               ' fill the spreadsheet               Worksheets("Main Sheet").Cells(Row, Column) = user               Row = Row + 1               If Row > 15 Then Row = 1 Column = Column + ...

XBrowse, supported by FWH function GetExelRange() simplifies browsing Data in Excel files. Here is a sample worksheet. http://img233.imageshack.us/img233/783/xbrxls.jpg Assuming the Excel file is saved as "xbrtest.xls" ( can be xlsx extention too), here ...

I have the same problem with Excel.
Juts created worksheet remains in background

... .t. endif Luego en mis funciones de guardar, cerrar fichero, etc. hago la comprobación de que el objeto da error: local omm := oexcel:CommandBars('Worksheet Menu Bar') if uerrorex = .t. MsgAlert('Para guardar o cerrar el libro salga antes del modo edicción') uerrorex := .f. return endif Por lo ...

... devuelve 'O', pero valtype(oexcel:ActiveWorkBook) devuelve el mismo error si está en modo edición. Si pudiera acceder a: oexcel:CommandBars('Worksheet Menu Bar'):Controls('Archivo'):Controls('Nuevo...'):Enabled() podría detectarlo, puesto que el menu de Archivo->Nuevo se deshabilita cuando ...

... = 12345  Regarding getting Data from Excel Using automation, you can write loops which go through a worksheet cell-by-cell reading the data. Although this technique is relatively simple, it appears to be universally acknowledged as being very slow. ...

... the current, but in a previous column from the current one a EJECT will be done automatically At the end of this class is a little function call WorkSheet that will make the job of DOS printing a lot easier. Enjoy it! */ #include "fivewin.ch" #include "fileio.ch" #translate ...

... ENDIF UNTIL nRead == PF_BUFLEN fClose(hFile) RETURN .T. //----------------------------------------------------------------------------// FUNCTION WorkSheet(cPort) LOCAL oPrn LOCAL cLine LOCAL nFor cLine := "" FOR nFor := 0 TO 7 cLine += Str(nFor,1)+Replicate(".",9) NEXT cLine ...