bb.donnay-software.com

Donnay Software Web Forums
It is currently Wed Aug 12, 2020 1:48 am

All times are UTC - 7 hours




Post new topic Reply to topic  [ 26 posts ]  Go to page 1, 2, 3  Next
Author Message
PostPosted: Sun May 10, 2020 11:00 pm 
Offline
User avatar

Joined: Sat Feb 04, 2012 2:23 am
Posts: 1349
Location: Russia, Southern federal district, city of Krasnodar
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.

_________________
http://lc.kubagro.ru/
https://www.researchgate.net/profile/Eugene_Lutsenko
http://ej.kubagro.ru/
http://ej.kubagro.ru/a/viewaut.asp?id=11


Top
 Profile  
 
PostPosted: Mon May 11, 2020 1:11 pm 
Offline
User avatar

Joined: Wed Feb 24, 2010 3:44 pm
Posts: 1189
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

_________________
greetings by OHR
Jimmy


Top
 Profile  
 
PostPosted: Tue May 12, 2020 8:14 am 
Offline
Site Admin
User avatar

Joined: Wed Jan 27, 2010 6:58 pm
Posts: 4149
Location: Boise, Idaho USA
You could try this:

Code:
#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()

_________________
The eXpress train is coming - and it has more cars.


Top
 Profile  
 
PostPosted: Tue May 12, 2020 8:58 am 
Offline
User avatar

Joined: Thu Jan 28, 2010 12:59 am
Posts: 789
Location: Berlin, Germany
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-)

_________________
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."


Top
 Profile  
 
PostPosted: Wed May 13, 2020 3:03 am 
Offline
User avatar

Joined: Thu Feb 11, 2010 1:39 pm
Posts: 490
Quote:
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


Top
 Profile  
 
PostPosted: Wed May 13, 2020 9:00 am 
Offline
User avatar

Joined: Wed Feb 24, 2010 3:44 pm
Posts: 1189
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?f=16&t=7610&p=93834

_________________
greetings by OHR
Jimmy


Top
 Profile  
 
PostPosted: Wed May 13, 2020 8:55 pm 
Offline
User avatar

Joined: Sat Feb 04, 2012 2:23 am
Posts: 1349
Location: Russia, Southern federal district, city of Krasnodar
Ich kann mich nicht im Forum registrieren: https://www.xbaseforum.de
Mag meine E-Mail-Adressen nicht

_________________
http://lc.kubagro.ru/
https://www.researchgate.net/profile/Eugene_Lutsenko
http://ej.kubagro.ru/
http://ej.kubagro.ru/a/viewaut.asp?id=11


Top
 Profile  
 
PostPosted: Thu May 14, 2020 12:33 am 
Offline

Joined: Thu Jan 28, 2010 1:22 am
Posts: 864
Location: Sijsele, Belgium
Hi,

See http://www.familie-brandel.de/dateien/dat_index_e.html
Also: http://news.alaska-software.com/readmessage?id=%3C4f739e7f$31706cfa$341f69@news.alaska-software.com%3E&group=public.xbase%2B%2B.generic

_________________
Best regards,

Chris.
www.aboservice.be


Top
 Profile  
 
PostPosted: Thu May 14, 2020 1:17 am 
Offline
User avatar

Joined: Thu Jan 28, 2010 12:59 am
Posts: 789
Location: Berlin, Germany
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.

_________________
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."


Top
 Profile  
 
PostPosted: Thu May 14, 2020 6:32 am 
Offline
User avatar

Joined: Sat Feb 04, 2012 2:23 am
Posts: 1349
Location: Russia, Southern federal district, city of Krasnodar
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.

_________________
http://lc.kubagro.ru/
https://www.researchgate.net/profile/Eugene_Lutsenko
http://ej.kubagro.ru/
http://ej.kubagro.ru/a/viewaut.asp?id=11


Last edited by Eugene Lutsenko on Thu May 14, 2020 7:02 am, edited 1 time in total.

Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 26 posts ]  Go to page 1, 2, 3  Next

All times are UTC - 7 hours


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group