+ 11

C++ and Excel

I want to write datas to desired rows and coloums(to excel file), also same thing for reading , But I could not find any informative sources , So is there anyone who can help me about it?

18th Apr 2019, 10:09 PM
Emre İRİŞ
Emre İRİŞ - avatar
15 Réponses
19th Apr 2019, 3:18 PM
silentlearner
silentlearner - avatar
+ 7
Have you looked into VBA?
20th Apr 2019, 1:39 AM
Sonic
Sonic - avatar
+ 5
Turning file type into csv is really good solution, but also I need to select coloums ,rows as I desired
19th Apr 2019, 5:58 AM
Emre İRİŞ
Emre İRİŞ - avatar
+ 5
Da2 Would you be more spesific? Where am I supposed to put commas? An example code or reference can be really helpfull
19th Apr 2019, 9:24 AM
Emre İRİŞ
Emre İRİŞ - avatar
+ 5
Okey What you do is not helping or guiding , All you say is to tell suggest me try more and I already did it
19th Apr 2019, 1:38 PM
Emre İRİŞ
Emre İRİŞ - avatar
+ 4
Yeah silentlearner this looks so promising to me :) Thanks I will try this one
19th Apr 2019, 4:56 PM
Emre İRİŞ
Emre İRİŞ - avatar
+ 3
Sonic Yeah I used VBA before , but I am gonna have to write all datas to a flash by using microcontroller , so written programme will be embedded to microcontroller It wont stay in pc
20th Apr 2019, 8:05 AM
Emre İRİŞ
Emre İRİŞ - avatar
+ 1
Export a spreadsheet to csv, you'll figure it out.
19th Apr 2019, 11:46 AM
Da2
Da2 - avatar
+ 1
Spaces, :, /, -, _, +, 1,*,%,(),#$;~;<;>;[];{}|;\; '', ', @,,.,=,!,?,. 😑 🙄 🤣 😥🤔🤗😏👏🤗👍🌻
19th Apr 2019, 2:18 PM
Asim Farheen
Asim Farheen - avatar
+ 1
Sonic good suggestion, i am pretty sure vba will have classes that deal with Emre İRİŞ project. Pls provide him with links
20th Apr 2019, 1:41 AM
Da2
Da2 - avatar
+ 1
Sonic, System integration is more demanding and challenging
20th Apr 2019, 8:08 AM
Da2
Da2 - avatar
+ 1
Why to convert files and lose formulas/cell format/etc while you can use library to work with excel files natively? For xlsx I like https://github.com/tfussell/xlnt, you can also find something suitable for older xls files.
21st Apr 2019, 9:28 AM
Илья Кузнецов
Илья Кузнецов - avatar
0
Read on the data structures used by electronic spreadsheets. But a brute force solution is to save the data as csv then import it.
19th Apr 2019, 3:56 AM
Da2
Da2 - avatar
0
Commas can solve that.
19th Apr 2019, 6:47 AM
Da2
Da2 - avatar
0
Emre İRİŞ I am sorry my suggestions did not help. Good luck on your project.
19th Apr 2019, 6:14 PM
Da2
Da2 - avatar