?
Solved

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

Posted on 1998-12-23
6
Medium Priority
?
721 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 7

Accepted Solution

by:
BlackMan earned 100 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

718 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