in reply to Re: %p issue on perl script
in thread %p issue on perl script

Hi,

Some how i solved the second issue. I set the font to that spread sheet as below and now i dont have any issue in printing non-english strings.

$Sheet2->Range("A100:Z100")->Font->{FontStyle}="Arial Unicode MS";

But again i stuck up with another issue on printing the string into a spreadsheet.

I am printing a string into an spreadsheet with an row input from an for loop. Below is the code snippet of an for loop for better understanding.

for($i=0;$i<$out_size;$i++) { $Sheet2 -> Range("A$i") -> {'Value'} = $gm_out[$i][0]; $Sheet2 -> Range("B$i") -> {'Value'} = $gm_out[$i][1]; $Sheet2 -> Range("C$i") -> {'Value'} = $gm_out[$i][2]; $Sheet2 -> Range("D$i") -> {'Value'} = $gm_out[$i][3]; }

Here the problem comes from an "Range". I am getting an error when i run this program an error pointing to "Range".

Please suggest me an idea on how to input the "Range" with an variable size so that i can print an array $gm_out$ix into the variable ranges of ROW in the columns A, B, C & D.

Please provide your help