Solved

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

Posted on 1998-12-23
6
678 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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

743 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now