Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Packages and Libraries
»
FPSpreadsheet
»
[Solved] - Problem saving a grid as Excel Format
Free Pascal
Website
Downloads
Wiki
Documentation
Bugtracker
Mailing List
Lazarus
Website
Downloads (Laz+FPC)
Packages (OPM)
FAQ
Wiki
Documentation (RTL/FCL/LCL)
Bugtracker
CCR Bugs
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
Class designer/editor
by
Aruna
[
Today
at 05:16:37 pm]
Listview how to custom or...
by
VisualLab
[
Today
at 04:59:00 pm]
Broken Icon Display on ma...
by
msintle
[
Today
at 04:46:35 pm]
Browser User Agent & Frie...
by
MarkMLl
[
Today
at 04:26:29 pm]
TListView.OnChange Event ...
by
msintle
[
Today
at 04:14:58 pm]
programming with Lazarus
by
srvaldez
[
Today
at 04:03:11 pm]
Extended Module Player
by
Gigatron
[
Today
at 03:08:43 pm]
Change execution order wh...
by
Khrys
[
Today
at 03:02:06 pm]
7zip DLL is super broken
by
rvk
[
Today
at 01:55:47 pm]
Searching for a safe alte...
by
marcov
[
Today
at 01:28:57 pm]
Hints.
by
seghele0
[
Today
at 12:29:35 pm]
CLI | Wildcard parameters...
by
Bart
[
Today
at 11:21:42 am]
TDBF Recordcount
by
rvk
[
Today
at 11:19:09 am]
Error code 5
by
ccrause
[
Today
at 11:14:19 am]
Font draw in customdraw i...
by
mikutu
[
Today
at 08:02:02 am]
Problems with Gitlab
by
Joanna
[
Today
at 07:35:08 am]
Cannot open Access databa...
by
Khrys
[
Today
at 06:59:12 am]
TMemo and paste from clip...
by
Aruna
[
Today
at 05:58:24 am]
environment variables
by
dbannon
[
Today
at 01:59:07 am]
TDBDateEdit component def...
by
wp
[September 11, 2024, 11:56:30 pm]
TStateMachine
by
matthius
[September 11, 2024, 11:40:00 pm]
Any support for Perpendic...
by
circular
[September 11, 2024, 09:05:59 pm]
Local Vars often inspect ...
by
Martin_fr
[September 11, 2024, 08:58:22 pm]
Problem with pasting text...
by
artist
[September 11, 2024, 08:55:36 pm]
Identifier capitalization...
by
DomingoGP
[September 11, 2024, 08:33:22 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: [Solved] - Problem saving a grid as Excel Format (Read 888 times)
zxandris
Full Member
Posts: 101
[Solved] - Problem saving a grid as Excel Format
«
on:
August 03, 2024, 06:47:33 pm »
I am pretty sure I'm missing something obvious but I've got a grid which is built from a simple csv (Which I had to load myself) and I want to save it in Excel Format, or another in time.
Code: Pascal
[Select]
[+]
[-]
wsSheet
.
SaveToSpreadsheetFile
(
dlgExport
.
filename
,
sfExcel8
,
true
)
;
That's the code I'm using and I have
Code: Pascal
[Select]
[+]
[-]
fpspreadsheetgrid
,
fpspreadsheetctrls
,
fpsTypes
,
in the uses clause for the unit/form. Can anyone tell me what I'm doing wrong here please?
CJ
«
Last Edit: August 04, 2024, 08:22:05 am by zxandris
»
Logged
wp
Hero Member
Posts: 12287
Re: Problem saving a grid as Excel Format
«
Reply #1 on:
August 03, 2024, 10:22:06 pm »
What is the error? What type is wsSheet?
Logged
zxandris
Full Member
Posts: 101
Re: Problem saving a grid as Excel Format
«
Reply #2 on:
August 03, 2024, 10:23:59 pm »
Tried to write a spreadsheet using an unsupported format and wsSheet is a simple tsWorksheetGrid.
Logged
wp
Hero Member
Posts: 12287
Re: Problem saving a grid as Excel Format
«
Reply #3 on:
August 04, 2024, 08:11:21 am »
Did you add unit xlsBiff8 to "uses"? FPSpreadsheet has a modular structure, and for every file format the reader/writer unit must be listed, or you add "fpsAllFormats" to register all file formats.
Logged
zxandris
Full Member
Posts: 101
Re: Problem saving a grid as Excel Format
«
Reply #4 on:
August 04, 2024, 08:13:46 am »
Thank you very much that appears to have worked. It does actually say as a hint it's not used in the unit, but it makes it work anyway!
Logged
wp
Hero Member
Posts: 12287
Re: Problem saving a grid as Excel Format
«
Reply #5 on:
August 04, 2024, 08:18:03 am »
Yes, that's because your code does not explicitly call any reader/writer function (this is done internally). If you'd once decide to remove "unused units" be careful to keep your reader/writer unit.
Logged
zxandris
Full Member
Posts: 101
Re: Problem saving a grid as Excel Format
«
Reply #6 on:
August 04, 2024, 08:21:50 am »
Thanks for the tip!
Logged
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Packages and Libraries
»
FPSpreadsheet
»
[Solved] - Problem saving a grid as Excel Format
TinyPortal
© 2005-2018