Page 1 of 3
How do I convert CSV = > Excel in Alaska?
Posted: Sun May 10, 2020 11:00 pm
by 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.
Re: How do I convert CSV = > Excel in Alaska?
Posted: Mon May 11, 2020 1:11 pm
by Auge_Ohr
Eugene Lutsenko wrote: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
Re: How do I convert CSV = > Excel in Alaska?
Posted: Tue May 12, 2020 8:14 am
by 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()
Re: How do I convert CSV = > Excel in Alaska?
Posted: Tue May 12, 2020 8:58 am
by 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.
Re: How do I convert CSV = > Excel in Alaska?
Posted: Wed May 13, 2020 3:03 am
by unixkd
Hi Jimmy
Do you have a wrapper for the libxlsxwriter that you can share with us ?
Thanks
Joe
Re: How do I convert CSV = > Excel in Alaska?
Posted: Wed May 13, 2020 9:00 am
by 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
Re: How do I convert CSV = > Excel in Alaska?
Posted: Wed May 13, 2020 8:55 pm
by Eugene Lutsenko
Ich kann mich nicht im Forum registrieren:
https://www.xbaseforum.de
Mag meine E-Mail-Adressen nicht
Re: How do I convert CSV = > Excel in Alaska?
Posted: Thu May 14, 2020 12:33 am
by skiman
Re: How do I convert CSV = > Excel in Alaska?
Posted: Thu May 14, 2020 1:17 am
by 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.
Re: How do I convert CSV = > Excel in Alaska?
Posted: Thu May 14, 2020 6:32 am
by Eugene Lutsenko
Tom wrote: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.