Solved

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

Posted on 1998-12-23
6
691 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
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

830 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