You cannot post messages because only members can post, and you are not currently a member.
|
 FAQ: Why does my Spreadsheet::WriteExcel not load correctly in Excel.
|
| |
Q. Why does my Spreadsheet::WriteExcel file not load in Excel or cause it to crash? In general it is hard to create a Spreadsheet::WriteExcel file will not load in Excel. However, an Excel file is a binary file so it is possible for it to become corrupt. The following are the main reasons why this might happen.... more »
|
|
|
FAQ: How do I update an existing Excel file
|
| |
Q. How do I update an existing Excel file A. An Excel file is a binary file within a binary file. It contains several interlinked checksums and changing even one byte can cause it to become corrupted. As such you cannot simply append or update an Excel file. The only way to achieve this is to read the entire file into memory, make the... more »
|
|
|
FAQ: How do you "Autofit" columns with Spreadsheet::WriteExcel.
|
| |
Q: How do you "Autofit" columns with Spreadsheet::WriteExcel. Excel provides a function called Autofit (Format->Columns->Autofit) that adjusts column widths to match the length of the longest string in a column. Excel calculates these widths at run time when it has access to information about string lengths and font information. This function... more »
|
|
|
FAQ: Reporting a bug in Spreadsheet::WriteExcel
|
| |
If you are reporting a bug in Spreadsheet::WriteExcel then here are some pointers. 1) Provide information on your system, version of perl and module versions. The following program will generate everything that is required. Put this information in your bug report. #!/usr/bin/perl -w print "\n Perl version : $]";... more »
|
|
|
WARNING: Spreadsheet::WriteExcel and Office Service Pack 3
|
| |
Q: Why do I get the following error when I open my
Spreadsheet::WriteExcel files in Excel with Office Service Pack 3:
"File Error: data may have been lost".
A: Office Service Pack 3 changes the default behaviour of Excel when
dealing with multiple data in a cell.
Discussion
==========... more »
|
|
|
Announce: Spreadsheet::WriteExcel version 2.26
|
| |
Spreadsheet::WriteExcel version 2.26 has been released to CPAN.
This release contains initial support for defined names in Excel,
fixes for issues with imported images and a few other minor fixes.
[link]
Note, Spreadsheet::WriteExcel is now on Github:... more »
|
|
|
formatting within strings?
|
| |
Spreadsheet::WriteExcel is wonderful, thanks for the great work.
I've been asked to program something I don't think it can do, that is,
write text strings with intra-string formatting.
For example I'd like to put in text strings that are partly but not
completely underlined. In HTML-speak this might be, for example... more »
|
|
|
64-bit issue?
|
| |
Hey guys, has anyone tried making spreadsheets in a 64-bit environment
yet? I've encountered a problem. Let me describe:
I am using Office 2007, latest patches.
I am using Spreadsheet::WriteExcel 2.25.
I'm running Perl 5.10.
1) Generate a spreadsheet within a 32-bit Windows XP environment
2) Copy the spreadsheet to a 64-bit Windows 7 environment.... more »
|
|
|
Centering an image
|
| |
John;
I have several png files that represent trends (up, down and no
change). They are 16px x 16px, Can they be centered using formats?
Currently they are flush left. Do I need to create the graphic as wide
as the column? Thge column width is 10 row height is 22.
|
|
|
Spreadsheet::WriteExcel update
|
| |
Hi,
For the last few months I have been overloaded with work and haven't
had any free time to develop WriteExcel or even to reply (promptly) to
questions.
This probably won't change in the short term (although given the
current climate I may find myself with a lot of free time on my hands
at any time).... more »
|
|
|
Excel to perl
|
| |
John;
I might be crazy,but I think there was a script that read an existing
excel file and created a perl program from it. Am I right? if so where
can I get it?
|
|
|
Bug report: formula parsing in Spreadsheet::WriteExcel
|
| |
...
...
use warnings;
use strict;
use Spreadsheet::WriteExcel;
my $workbook=Spreadsheet::WriteEx cel->new("bad_file.xls");
my $sheet = $workbook->add_worksheet();
$sheet->write_col(0,0,[1 .. 10]);
$sheet->write_formula(0,1,3.14 159);
$sheet->write_formula(1,1,'=MA TCH(B1,A1:A10)'); # <-- Problem on cell... more »
|
|
|
Column Hiding FAST, Row Hiding SLOOOOOOOW!
|
| |
The last thing I want to do to the worksheet I'm exporting is hide all
the extra rows and columns.
This snippet hides the columns quickly and with no bloat:
$worksheet->set_column('Q:IV', undef, undef, 1);
However, set_row doesn't seem to work on more than one row at a time.
This only sets row 66 and ignores the rest:... more »
|
|
|
Vlookup in Excel returns False or 0 when executing
|
| |
Hi,
I am in the process of self teaching myself Perl and in particular
WriteExcel. I have designed a whole workbook but when I come to
approach doing the Vlookup I hit a snag!
$formula = q{=IF(VLOOKUP(C3,Data Rev!A:B,2,0))};
$formula = $excel_sheet1->store_formula($ formula);
@$iferror = map {s/_ref2d/_ref2dV/;$_} @$iferror;... more »
|
|
|
|
A group to discuss and ask questions about the Spreadsheet::WriteExcel Perl module.