How do I convert CSV = > Excel in Alaska?

[Eugene Lutsenko]

How do I convert CSV = > Excel in Alaska? It is important that this is a universal solution. I have done this many times for specific cases.

[Auge_Ohr]

How do I convert CSV = > Excel in Alaska?

do you want to "make" a CVS or are you asking how to create Excel file ?

Excel use ANSI or UNICODE so CVS must have it before import into Excel.

other Way is to write a Excel Sheet using 3-PP Software like libxlsxwriter
https://github.com/jmcnamara/libxlsxwriter

for harbour i use this Wrapper
https://github.com/FTrautwein/hblibxlsxwriter

[rdonnay]

You could try this:

Code: Select all

#DEFINE xlWorkbookNormal  -4143

oExcel := CreateObject("Excel.Application")

cCsvFile := 'workbook.csv'
cExcelFile := 'workbook.xls'
cPassword := nil

oBook := oExcel:Workbooks:Open(cCsvFile)
oBook:SaveAs(cExcelFile,xlWorkbookNormal,cPassword)

oBook:close()
oBook:destroy()
oExcel:Quit()
oExcel:Destroy()

[Tom]

Roger, c'mon. It's sooooo much funnier to struggle with strange code from anywhere and for different languages than to just open a damned CSV file with Excel and save it afterwards.

[unixkd]

other Way is to write a Excel Sheet using 3-PP Software like libxlsxwriter
https://github.com/jmcnamara/libxlsxwriter

Hi Jimmy

Do you have a wrapper for the libxlsxwriter that you can share with us ?

Thanks

Joe

[Auge_Ohr]

hi,

i make a Misttake

libxlsxwriter is for harbour while libxl.dll is for Xbase++
https://www.libxl.com/

i have NOT made a Xbase++ Wrapper for libxlsxwriter.
for libxl.dll there is a Wrapper in German Xbase++ Forum ... i have to search it

---

found it here https://www.xbaseforum.de/viewtopic.php ... 10&p=93834

[Eugene Lutsenko]

Ich kann mich nicht im Forum registrieren: https://www.xbaseforum.de
Mag meine E-Mail-Adressen nicht

[skiman]

Hi,

See http://www.familie-brandel.de/dateien/dat_index_e.html
Also: http://news.alaska-software.com/readmes ... 2B.generic

[Tom]

The German Xbase++-forum is blocked for several TLDs. You need a com/net/de/at/(...)-adress for signing in. Most of the attacks come from russia and china. Since it's a german (speaking) forum, we didn't expect to have guests from russia there.

[Eugene Lutsenko]

The German Xbase++-forum is blocked for several TLDs. You need a com/net/de/at/(...)-adress for signing in. Most of the attacks come from russia and china. Since it's a german (speaking) forum, we didn't expect to have guests from russia there.

Hi, Tom!

Thank you for your clarification. I didn't want to attack, but to learn. And maybe to some extent share experience. When I tried to register, I used my corporate email addresses of the two universities where I work:
https://kubsau.ru/education/chairs/comp ... taff/3965/
https://kubsu.ru/ru/public-portfolio/39926
The forum always identifies these addresses as unreliable, spam sources, etc.