Hi,
I have a question about using C to write excel file.
There is a way to write into a sheet into a file excel, like this:
FILE * File;
pMyFile = fopen("test.xls", "w+");
fprintf(File, "\n\n"); /* go to the row 2 of the column A*/
fprintf(File, "%s", "Hi pippo!"); /* write... (7 Replies)
Hi,
There is this requirement to create multiple work sheets in an MS Excel file through UNIX.
We normally can create one work sheet in unix by either tab or comma delimiting and appending .xls or .csv to the file name, but can we create multiple work sheets.
Regards,
Puspendu (1 Reply)
Hi,
I have generated an excel sheet using a shell script. i have converted the output text file to an excel and got the desired output. However, in a particular column in the excel the values of the numbers start with 0.
e.g. 078393343, 00342442, etc.
But, in the resulting excel I get as... (2 Replies)
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)
Hi,
I need your help in sedning sql queries output to different excel sheets.
My requirement is like this:
Query1: Select name from table1 where status = 'Complete'
Query2: Select name from table1 where status = 'Failed'
Query3: Select name from table1 where status = 'Ignored'
... (4 Replies)
Hi
I need to modify an excel file in perl and for which I installed perl in
Linux
1. Open a existing excel file
2. delete an unwanted Sheet called "summary"
3. and i want to insert some data into range of cells ( B1:B11)
4. Remove unwanted value called "Sum" repeated in the... (1 Reply)
Hi UNIX Gods!
Is it possible to merge two cells in .csv file using unix commands?
Imagine that this is my present csv file opened via excel:
Gate Reports| |
fatal alerts | 200 |
is is possible to make it look like this using unix?
Gate Reports |
fatal... (1 Reply)
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)
I have requirement to write two CSV files to one single excel with multiple sheets.
Data present in the two files should sit in excel as different sheets.
How can we achieve this using shell script?
1.csv 2. csv
1,2,3,4 5,6,7,8
XXXXX YYYYY
Res.excel
1.csv data... (1 Reply)
Dear all,
I have a large dictionary database which has the following structure
source word=target word
e.g.
book=livre
Since the database is very large in spite of all the care taken, it so happens that at times the source word is repeated
e.g.
book=livre
book=tome
Since I want to... (7 Replies)
Discussion started by: gimley
7 Replies
LEARN ABOUT DEBIAN
photon
PHOTON(1)PHOTON(1)NAME
photon - generates photo albums
SYNOPSIS
photon [OPTIONS] [PATH]
DESCRIPTION
Photon generates clean, yet configurable, static HTML photo galleries. All of the work is done from the command line, and the resulting
output can easily be configured by changing the template files found in /usr/share/photon/templates.
To create a new template (skin), first create a new directory:
mkdir -p ${HOME}/.photon/templates/my_theme/
Then copy the contents of /usr/share/photon/templates/photonv1/ to this new directory. Photon only needs three files to build pages:
index.html
used to display the content of a folder
image.html
used to display the page for an image
movie.html
used to display the page for a movie
If a file is missing, then photon will throw an error and will not run.
HOW TO BUILD A GALLERY
Quick start
$ photon -o myoutputdir /photos
Use the gimp plugin
$ photon --resize-plugin=gimp -v -o myoutputdir /photos
Change the size for all images and the thumbnail and keep the original photo
$ photon --sizelist=0,1600x1200,800x600 --thumbsize=320x240 -o myoutputdir /photos
Create a gallery from your custom template (skin)
$ photon -k my_theme -o myoutputdir /photos
See photon help
$ photon --help
OPTIONS -a | --awstats
Insert Javascript for Awstats
--awstats-url=URL
Change default value for Awstats script url
-c NAME | --comment
Name of the comment file (default .comments)
-d NUM | --display-columns=NUM
Number of columns in index (default 3)
-E | --no-exif
Don't include EXIF information in HTML file
-f | --force
Overwrite non-image generated files (html, javascript, etc) (default no)
-ff | --force --force
Overwrite image files (default no)
-h | --help
Print this help
-I | --no-index
Do not generate the high level index.html
-J | --no-javascript
Do not use javascript (no shortcuts, ... )
-k | --skin=THEME
Skin selector (default photonv1)
--print-skins
Print out available skins (templates)
-l NUM | --display-lines=NUM
Number of lines in index (default 5)
-m | --movie
Movie mode, include link to movie (*.mov)
-o NAME | --output-directory=NAME
Name of the output directory
-s LIST | --sizelist=LIST
Image sizes (default 0,1024x768,800x600,640x480). Zero, which is the default, uses the original resolution. W x H specifies the width
and height of the image in pixels.
-t SIZE | --thumbsize=SIZE
Size of thumbnails (default 160x120)
-v | --verbose
Verbosely print information
-V | --version
Print program version number
-z | --compress
Compress the original image if selected (default copy the image)
--exif-bordercolor=COLOR
Exif window border color (default #008000)
--exif-bgcolor=COLOR
Exif window background color (default #f0fff0)
--exif-fgcolor=COLOR
Exif window text color (default black)
--body-bgcolor=COLOR
Body background color (default #ccccff)
--img-bgcolor=COLOR
Image background color (default white)
--exclude=PATTERN
Exclude files matching PATTERN
--resize-plugin=PLUG
Where PLUG is the program used to create thumbnails internal: fastest method (default) gimp: use Gimp>1.x (better quality)
--resize-quality-low=NUM
Quality for small image. 0 (bad) and 100 (good)
--resize-quality-high=NUM
Quality for big image 0 (bad) and 100 (good)
--gimp-program=PROG
use PROG for gimp
SHORTCUTS WHILE VIEWING AN IMAGE
n/SPACE Go to the next image (with the same resolution)
p/BACKSPACE Go to the previous image (with the same resolution)
s Start/Stop the slideshow
+/- Increase/Decrease by one second the slideshow's period
h Show shortcut and help
i Show Exif information
z Change to the higher resolution [NOT YET IMPLEMENTED]
SEE ALSO gimp(1)AUTHOR
Written by Luc Saillard, <luc@saillard.org>
Main web site: http://www.saillard.org/programs_and_patches/photon/
This manual page was written by Kevin Coyner <kcoyner@debian.org> for the Debian project but may be used by others.
12/16/2006 PHOTON(1)