10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies
2. Shell Programming and Scripting
Hi All,
I have written an cgi perl script that displays an image(Excel image) and when clicked on that Image I need to download a excel sheet.
I made sure that excel sheet exists in the folder with the given name but still I am not able to download the sheet.
print "<center><table... (2 Replies)
Discussion started by: scriptscript
2 Replies
3. Shell Programming and Scripting
I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix
But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed.
What to do...Please... (7 Replies)
Discussion started by: mud_born
7 Replies
4. Shell Programming and Scripting
Hi all,
I use "Spreadsheet::ParseExcel::SaveParser" to
- read a existing excel file with :
$Parser = Spreadsheet::ParseExcel::SaveParser->new();
$HeaderFile = $Parser->Parse("XLS_FILE_ACCESS");
- modify some values in somes cell with :
$worksheet->AddCell($row_target,$col_max,... (3 Replies)
Discussion started by: Yom
3 Replies
5. Shell Programming and Scripting
Dear all,
I got a template excel file which contains several worksheets. Each worksheet contains some formulas in the cells.
I am using the perl script to read a CSV file and then put the data of CSV into template excel file(first worksheet) and then save it as new file name using ... (0 Replies)
Discussion started by: eldonlck
0 Replies
6. UNIX for Dummies Questions & Answers
Dear all,
I have a hash in my data file and I'd like to output the data contained within as a graph (can be lines or histogram form) but I dont know how to do this with Perl.
Can somone suggest how I can have a graph with Keys of the hash being on the X-axis and the Values for the keys plotted on... (1 Reply)
Discussion started by: pawannoel
1 Replies
7. AIX
Bonjour,
Après avoir découvert Nmon puis la macro excel, je souhaite comprendre la description de graphe
_________________
SYS_SUMM
CPU% ???
IO/sec ???
_________________
CPU_ALL
User% ???
Sys% ???
Wait% ???
_________________
DISK_SUMM
Disk Read KB/s = Lecture disk en kilo bytes... (6 Replies)
Discussion started by: stephane99
6 Replies
8. Programming
To successfully export a perl GD::Graph object to a graphics file (e.g. a .png file), do you do the following ?
# Set graph data
$graph->set(....);
$graph->plot(\@graph_data);
open(IMG,'>file.png') or die $!;
binmode IMG;
print IMG $graph->png;
close IMG;
Reason Im asking is... (1 Reply)
Discussion started by: JamesGoh
1 Replies
9. Shell Programming and Scripting
Hi,
I am trying to find a way to read an excel work book with multiple worksheets.
And write each worksheet into a new excel file using perl. My environment is Unix.
For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies
10. Shell Programming and Scripting
Hi
I plan to read an excel file (using Spreadsheet::ParseExcel) and create a clone of it with some other name (using Spreadsheet::WriteExcel).
I am able to get the skeleton by reading cells in every pair of every worksheet. But I am not able to get the format string of these cells. I want the... (5 Replies)
Discussion started by: srinivay
5 Replies