From: "Dr.Ruud"
> On 15/05/2013 21:35, David Precious wrote:
> > On Wed, 15 May 2013 10:34:02 +0100
> > Gary Stainburn wrote:
>
> >> Is it possible to write text cells where part of the string is
> >> highlighted in red? If so, how can I do it?
> >
> > I'm fairly sure the format of a cell applie
On 15/05/2013 21:35, David Precious wrote:
On Wed, 15 May 2013 10:34:02 +0100
Gary Stainburn wrote:
Is it possible to write text cells where part of the string is
highlighted in red? If so, how can I do it?
I'm fairly sure the format of a cell applies to the whole content of
that cell - can
On Wed, 15 May 2013 10:34:02 +0100
Gary Stainburn wrote:
> Is it possible to write text cells where part of the string is
> highlighted in red? If so, how can I do it?
I'm fairly sure the format of a cell applies to the whole content of
that cell - can you do what you're asking for in Excel or s
On 7/16/07, a_arya2000 <[EMAIL PROTECTED]> wrote:
Thanks for your extra ordinary help guys.
Actually, I already run similar type of script which
created a spreadsheet with maximum member of rows and
columns, the file size was 136 MB, it worked fine.
Now you can conclude there is something wrong w
Thanks for your extra ordinary help guys.
Actually, I already run similar type of script which
created a spreadsheet with maximum member of rows and
columns, the file size was 136 MB, it worked fine.
Now you can conclude there is something wrong with my
script. However, when the script read a txt
On 7/16/07, Chas Owens <[EMAIL PROTECTED]> wrote:
On 7/16/07, a_arya2000 <[EMAIL PROTECTED]> wrote:
> By the way, my file size around 22 MB so, is it
> possible that Spreadsheet::WriteExcel::Big is not good
> enough for this size?
snip
What follows is a test script you can use to determine if it
On Mon, 2007-07-16 at 14:23 -0700, a_arya2000 wrote:
> I have like around 24K rows. Thank you.
Sounds like a design problem. Use a database and connect the excel
spreadsheet to that data source. Seems a lot easier.
--
Ken Foskey
FOSS developer
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
F
On 7/16/07, a_arya2000 <[EMAIL PROTECTED]> wrote:
By the way, my file size around 22 MB so, is it
possible that Spreadsheet::WriteExcel::Big is not good
enough for this size?
snip
What follows is a test script you can use to determine if it is your
code or Spreadsheet::WriteExcel::Big (or possi
o: beginners@perl.org
> > Cc: a_arya2000
> > Subject: Re: Spreadsheet::WriteExcel problem with
> large file
> >
> > By the way, my file size around 22 MB so, is it
> > possible that Spreadsheet::WriteExcel::Big is not
> good
> > enough for this size?
>
> -Original Message-
> From: a_arya2000 [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 16, 2007 14:06
> To: beginners@perl.org
> Cc: a_arya2000
> Subject: Re: Spreadsheet::WriteExcel problem with large file
>
> By the way, my file size around 22 MB so, is it
>
By the way, my file size around 22 MB so, is it
possible that Spreadsheet::WriteExcel::Big is not good
enough for this size?
--- a_arya2000 <[EMAIL PROTECTED]> wrote:
> Thank you very much for suggestions guys, I tried
> using Spreadsheet::WriteExcel::Big but still having
> the same issue. I am n
On 7/16/07, a_arya2000 <[EMAIL PROTECTED]> wrote:
Thank you very much for suggestions guys, I tried
using Spreadsheet::WriteExcel::Big but still having
the same issue. I am not sure, what I am doing wrong.
My file size is indeed more than 7 MB.
Thank you,
Partha Dhar
Did you try the suggestion
Thank you very much for suggestions guys, I tried
using Spreadsheet::WriteExcel::Big but still having
the same issue. I am not sure, what I am doing wrong.
My file size is indeed more than 7 MB.
Thank you,
Partha Dhar
--- Raja Vadlamudi <[EMAIL PROTECTED]> wrote:
> Use Spreadsheet::Big module if
Use Spreadsheet::Big module if the file size happens to be larger than 7 MB.
The latest Spreadsheet module will have this Big module integrated, but if
you are using older version, then you need to use this Big module.
On 7/16/07 8:46 AM, "Rob Dixon" <[EMAIL PROTECTED]> wrote:
> a_arya2000 wrote
a_arya2000 wrote:
Hi, the problem is, when write large spreadsheets of 20,000 rows or
so, the module finishes without error, but when I try to open the
spreadsheet with Excel I get error messages about the spreadsheet
being 'unrecoverably scrambled'. I've never had a problem with it
except for t
#x27;
Cc: [EMAIL PROTECTED]
Subject: RE: Spreadsheet::WriteExcel Column width
That is what I am currently doing.
So $maxwidth= length $mylargeststring
But if I then set the width to that length it does not work. Its still
to short.
Any ideas?
-Original Message-
From: Wagner, David ---
Paul Kraus wrote:
> That is what I am currently doing.
> So $maxwidth= length $mylargeststring
> But if I then set the width to that length it does not work. Its still
> to short.
>
> Any ideas?
>
You might add a couple to the size of the length, but otherwise I would do all
my checking
, August 21, 2003 3:46 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Spreadsheet::WriteExcel Column width
Paul Kraus wrote:
> Is there any way to set the column width to the be as wide as the
> longest cell in that column?
>
> Paul Kraus
Paul Kraus wrote:
> Is there any way to set the column width to the be as wide as the
> longest cell in that column?
>
> Paul Kraus
$MyWorkSheet->set_column(Col1, Col2, widthdesired);
Now to get width desired, need to do a length of the data being processed and save
From: "Dan Muey" <[EMAIL PROTECTED]>
> I think unix uses \n and winders uses \n\r so you may need to use
\n\r
> or \r instead of \n
It should be \r\n (also read CRLF).
And Macs (the old ones) used \r.
> From: Paul Kraus [mailto:[EMAIL PROTECTED]]
>
> I wrote a script that generates an excel f
I think unix uses \n and winders uses \n\r so you may need to use \n\r or \r instead
of \n
Or someother line ending \f or??
Dan
> -Original Message-
> From: Paul Kraus [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 16, 2003 7:45 AM
> To: Perl
> Subject: Spreadsheet::WriteExcel -
I'm not sure about the problem you are having, you could try using the
Win32::OLE module and some of the following code, this works fine for me.
sub save_data {
if ($ARGV[0] =~ /man/i) {
print "Do you want to save the results as an Excel file?: ";
chomp($an
This worked for me... I found it in a book (so I'm not sure what happens
and exactly why) while looking how to read from Excel workbooks. (First
thing I need to do is upgrade my version of Perl, then I'll try the module
you refer to below.
Anyway, give this a try:::
use Win32;
use OLE;
$exce
23 matches
Mail list logo
