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. 8-)

Re: How do I convert CSV = > Excel in Alaska?

Posted: Wed May 13, 2020 3:03 am
by 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

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.