Solved

Save StringGrid content to .xls (excel file) ??

Posted on 1998-12-23
6
686 Views
Last Modified: 2010-04-04
Are there any function/ easy way to save the content in the StringGrid to excel file... I really mean easy way
0
Comment
Question by:mrbird
6 Comments
 
LVL 7

Accepted Solution

by:
BlackMan earned 50 total points
ID: 1352657
0
 
LVL 7

Expert Comment

by:jconde
ID: 1352658
Mrbird, theres a String / Image Grid Component called ADVStringGrid which is freeware (no src included)  This component, besides being the best string grid i've seen, has a method called SavetoExcel('Filename.xls')

Even though you're not using it, I suggest you take a look at it since it's very good, It has all the features you will need (In place editor, graphics, sorting, loading from files, saving to files, etc...) and it will definiteley help you in the future.

Regards,

Jorge
0
 
LVL 7

Expert Comment

by:jconde
ID: 1352659
Mrbird, theres a String / Image Grid Component called ADVStringGrid which is freeware (no src included)  This component, besides being the best string grid i've seen, has a method called SavetoExcel('Filename.xls')

Even though you're not using it, I suggest you take a look at it since it's very good, It has all the features you will need (In place editor, graphics, sorting, loading from files, saving to files, etc...) and it will definiteley help you in the future.

Regards,

Jorge
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

Author Comment

by:mrbird
ID: 1352660
Thank you Jorge
0
 
LVL 1

Expert Comment

by:slautin
ID: 1352661
Very easy way...
1.Via file: convert your any grid or list values into CSV
file. Can use same characters for separate fields ';'-for example and NL for string. Don't forget to delete or replace #13 and #10 symbols with blank in memo-fields.
2. Via clipboard : use tab symbol for field separator and NL - for string separator. In Exel - 'Paste' menu item.

I did it more then once.
Mail me : slautin@yahoo.com
0
 
LVL 1

Expert Comment

by:slautin
ID: 1352662
Very easy way...
1.Via file: convert your any grid or list values into CSV
file. Can use same characters for separate fields ';'-for example and NL for string. Don't forget to delete or replace #13 and #10 symbols with blank in memo-fields.
2. Via clipboard : use tab symbol for field separator and NL - for string separator. In Exel - 'Paste' menu item.

I did it more then once.
Mail me : slautin@yahoo.com
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

774 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question