08-24-2009
There are no stupid questions. But there are questions you should google first
That being said, in Excel, make sure you save your workbook first, and the click File | Save As... (if 2007 click the circle thingy at the top left and then Save As...). Change "Save as type:" to "CSV (Comma delimited)", give it a name, click save.
Remember that this will just be 1 worksheet, not the entire workbook, and it only saves data. Formulas, formats, etc., don't get saved in csv.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Can you pls help on writing ASCII files? For example, how to you put SUPPLIER NO and NAME in an ASCIIfile? (1 Reply)
Discussion started by: yialousa
1 Replies
2. Programming
Anyone knows how to open an ASCII file by using C
Thanks
:D (2 Replies)
Discussion started by: Wing m. Cheng
2 Replies
3. UNIX for Advanced & Expert Users
Hi,
How to view binary files in ASCII format.????????????????
Bye (2 Replies)
Discussion started by: manjunath
2 Replies
4. UNIX for Dummies Questions & Answers
We need to scramble data in a number of ASCII files. Some of these files are extremely large (1.2 GB). By scrambling, I mean that we need to substitute certain strings, which number around 400, with scrambled strings. An example has been given below
If "London" occurs in the file, then it... (2 Replies)
Discussion started by: SanjivNagraj
2 Replies
5. UNIX for Dummies Questions & Answers
how do I display the total number of words in a file which is of the type ascii text (1 Reply)
Discussion started by: madtim
1 Replies
6. Shell Programming and Scripting
Hello All,
I have a query inside a shell script and it will retun a 1000 rows result set. how can i take the output into an excel file from the script for better viewing the results.
Thanks,
Sateesh (4 Replies)
Discussion started by: kotasateesh
4 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I had to do something I could do in a way that worked fine, but I'm still wondering if there's a shorter way (which I think there is)...
I had to find only the ASCII files of a directory, and then work with them (that is, not only showing on screen)
What I did was
ls | xargs... (4 Replies)
Discussion started by: Casey
4 Replies
8. UNIX for Advanced & Expert Users
When you are dealing with ASCII files it easy to check on line endings type. You can just use the file command. You are not always lucky enough to be dealing with ASCII files. So in the cases that you don't have ASCII files how can you check what type of line endings you have? Please list all... (5 Replies)
Discussion started by: cokedude
5 Replies
9. Shell Programming and Scripting
Hi,
At the minute I am using a script to gather weekly SAR stats and put them into an excel scpreadsheet using perl.
I then get that spreadsheet and manually add in a chart on a new worksheet, Can i add this step into the script?
and if so how?
here is the part of my script that creates the... (9 Replies)
Discussion started by: Bdoydie
9 Replies
10. Shell Programming and Scripting
Anyone know how we can implement excel trimmean avg in Unix. possible by AWK
Sample File
scr1 100
scr1 2000
scr2 320
scr1 50
scr1 10
scr2 2
scr2 220
scr1 4234
scr2 2435
scr2 2
scr3 345
scr2 356
expected Output, which was using =trimmean(scr1 values, ignore 50% of values from... (8 Replies)
Discussion started by: mychbears
8 Replies
LEARN ABOUT DEBIAN
spreadsheet::writeexcel::chart::pie
Spreadsheet::WriteExcel::Chart::Pie(3pm) User Contributed Perl Documentation Spreadsheet::WriteExcel::Chart::Pie(3pm)
NAME
Pie - A writer class for Excel Pie charts.
SYNOPSIS
To create a simple Excel file with a Pie chart using Spreadsheet::WriteExcel:
#!/usr/bin/perl -w
use strict;
use Spreadsheet::WriteExcel;
my $workbook = Spreadsheet::WriteExcel->new( 'chart.xls' );
my $worksheet = $workbook->add_worksheet();
my $chart = $workbook->add_chart( type => 'pie' );
# Configure the chart.
$chart->add_series(
categories => '=Sheet1!$A$2:$A$7',
values => '=Sheet1!$B$2:$B$7',
);
# Add the worksheet data the chart refers to.
my $data = [
[ 'Category', 2, 3, 4, 5, 6, 7 ],
[ 'Value', 1, 4, 5, 2, 1, 5 ],
];
$worksheet->write( 'A1', $data );
__END__
DESCRIPTION
This module implements Pie charts for Spreadsheet::WriteExcel. The chart object is created via the Workbook "add_chart()" method:
my $chart = $workbook->add_chart( type => 'pie' );
Once the object is created it can be configured via the following methods that are common to all chart classes:
$chart->add_series();
$chart->set_title();
These methods are explained in detail in Spreadsheet::WriteExcel::Chart. Class specific methods or settings, if any, are explained below.
Pie Chart Methods
There aren't currently any pie chart specific methods. See the TODO section of Spreadsheet::WriteExcel::Chart.
A Pie chart doesn't have an X or Y axis so the following common chart methods are ignored.
$chart->set_x_axis();
$chart->set_y_axis();
EXAMPLE
Here is a complete example that demonstrates most of the available features when creating a chart.
#!/usr/bin/perl -w
use strict;
use Spreadsheet::WriteExcel;
my $workbook = Spreadsheet::WriteExcel->new( 'chart_pie.xls' );
my $worksheet = $workbook->add_worksheet();
my $bold = $workbook->add_format( bold => 1 );
# Add the worksheet data that the charts will refer to.
my $headings = [ 'Category', 'Values' ];
my $data = [
[ 'Apple', 'Cherry', 'Pecan' ],
[ 60, 30, 10 ],
];
$worksheet->write( 'A1', $headings, $bold );
$worksheet->write( 'A2', $data );
# Create a new chart object. In this case an embedded chart.
my $chart = $workbook->add_chart( type => 'pie', embedded => 1 );
# Configure the series.
$chart->add_series(
name => 'Pie sales data',
categories => '=Sheet1!$A$2:$A$4',
values => '=Sheet1!$B$2:$B$4',
);
# Add a title.
$chart->set_title( name => 'Popular Pie Types' );
# Insert the chart into the worksheet (with an offset).
$worksheet->insert_chart( 'C2', $chart, 25, 10 );
__END__
AUTHOR
John McNamara jmcnamara@cpan.org
COPYRIGHT
Copyright MM-MMX, John McNamara.
All Rights Reserved. This module is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.
perl v5.10.1 2010-02-02 Spreadsheet::WriteExcel::Chart::Pie(3pm)