FiveTech Software tech support forums

Otto I am taking an Excel spreadsheet whos data is taken from a web form. I then have to take that Excel file and write a conversion program that starts at column 1 thru the end column ( whatever ) and take all those values and stuff them ...

Anybody had any luck with accessing Listboxes in excel using OLE. I have a spreadsheet with a Listbox in about every cell. The user is suppose to select the value from the list box to fill it out. I am trying to fill it out using Fivewin and Ole. Don't have complete ...

Good afternoon. Would there be a way to do something similar to generate a spreadsheet in Excel, not using the Fast routine for that, but using My ex routine: FrPrn:SetProperty("XLSExport", "OpenExcelAfterExport" , .F.) // Abrir o excel FrPrn:SetEventHandler("XLSExport","OnSendXls",{|ParamsArray|MySendXls(FrPrn,cPdfFile)})

Olá Jimmy,
Thanks for the tip.

I downloaded the lib, I found it interesting, do you have any small examples for FiveWin and Harbor

In my system, there are a lot of reports generated in Spreadsheet, and it would be great to be able to open them without Excel

... file. This is especially useful since it supports the use of filters on the original data EXCEL - We also had an option for exporting to an Excel spreadsheet.

... and Outlook. I'm suprised that there aren't more question about this subject because almost any software has to connect to a word processor, a spreadsheet, a calendar or e-mail. I need the necessary instructions in FWH to build this connection. But I can't find anyone with enough experience ...

... of no connection the html file is not visible in its entirety The Xbrowse class has its own method (to html) but it works with the presence of a spreadsheet type software installed on the computer, so it uses all the potential of Excel to convert it into html I have tried to make a small function ...

... do these things ( it create a webpage with css from bootstrap ) and the oBrw: toHtml () method of xbrowse class won't work if you don't have spreadsheet software installed on your computer

Menuitem "Save as Html" ACTION oGrid:ToHTML() Why ask me a Spreadsheet software ? and if the user not have Excel or Openoffice or another spreadsheet cannot converte the xbrowse datas into html ? and with oBrw:ToHtml() anyway I couldn't for the ...

Silvio.Falconi wrote:Is there no remote possibility of extracting data from an excel spreadsheet without having Microsoft Excel installed?

You can use ADO to read the Excel data without having Excel installed on your PC

... the mystery ... . and I was convinced that it could work even without excel Is there no remote possibility of extracting data from an excel spreadsheet without having Microsoft Excel installed?

When creating an Excel object, I want to align some columns to the center. This is a common selection within Excel.

What do I send to Excel when creating a spreadsheet to make this happen. I see info on colors, width, content ... but nothing on alignment.

Thank you.

... ) to connect to the installed Outlook app, and filter out certain email messages & subjects, and then search through a spreadsheet & do some other stuff. In the minigui debugger, the outlook object - and other related objects - show up as just Class WIN_OLEAUTO object ...

Hello!

I need to export an xbrowse query to an Excel spreadsheet, but the user can edit it.
Any tips?

Thank you!

Rodrigo Melo

... can easily export them into comma-delimited/tab-delimited/xml/html file or copy them to the clipboard and then paste them into Excel or any other spreadsheet application. https://www.nirsoft.net/programmer_tools.html Regards,