Visual Studio 2008 comes bundled with a large number of icons, bmps and pngs that can come in extremely useful if youare putting together a Winforms application. I have used this before with 2005 but am never able to remember it!
So to get these files just go to c:\program files\microsoft visual studio 9.0\common7\VS2008ImageLibrary\1033 where you will find a zip with all the files available! As for VS2005 and earlier possibly - I would try looking in similarly named but versioned folders.
Let's see if typing this will help me remember!
Thursday 25 June 2009
Friday 19 June 2009
How do you reference other workbooks directly in Excel?
I use Excel a lot and love it but there you go I'm pretty sad!! When I do use it I do so pretty much exclusively with one workbook and multiple sheets. Now using Excel today I wanted to use an external sheet and perform a VLOOKUP, nothing revolutionary I know.
The thing was I wanted to type my formula in by hand, and the truth was I couldn't - it was a dreadful feeling!! lol. Ok, so I used the parameter editor to get some help. you know the little fx button next to the formula bar and learnt a few interesting facts:
Ok so initially I had the spreadsheet I wanted to link to open, I clicked the tab and range for the VLOOKUP and hey presto, thanks Excel its all fine and dandy. When you look at this formula, while the linked spreadsheet is open, you will notice that the reference is along the lines of [workbook.xls]tabname!cell:range. What is interesting to note if you then close you linked spreadsheet, Excel modifies the formula to 'drive:\path\of\workbook\[workbook.xls]tabname'!cell:range - which in my mind would be what I needed to type had I manually created the formula - and my goal might I add!
I did want to take this a little further and dynamically create the path since I knew I would always have the lookup source in the same folder. So I was going to use CELL("filename") strip off the filename and concatenate this path to my workbook reference. This didn't work, so I thought I would use the INDIRECT() function but googling more other people mentioned this does not work with closed workbooks. So I failed here, and since some of the work I am doing is using Excel automation I am instead passing this full path to the .Formula property and it does then work. Apparently, and I haven't investigated this, there is an add on called something like indirect.ext which will allow indirect to work with closed workbooks... I will try to have another look soon!
The thing was I wanted to type my formula in by hand, and the truth was I couldn't - it was a dreadful feeling!! lol. Ok, so I used the parameter editor to get some help. you know the little fx button next to the formula bar and learnt a few interesting facts:
Ok so initially I had the spreadsheet I wanted to link to open, I clicked the tab and range for the VLOOKUP and hey presto, thanks Excel its all fine and dandy. When you look at this formula, while the linked spreadsheet is open, you will notice that the reference is along the lines of [workbook.xls]tabname!cell:range. What is interesting to note if you then close you linked spreadsheet, Excel modifies the formula to 'drive:\path\of\workbook\[workbook.xls]tabname'!cell:range - which in my mind would be what I needed to type had I manually created the formula - and my goal might I add!
I did want to take this a little further and dynamically create the path since I knew I would always have the lookup source in the same folder. So I was going to use CELL("filename") strip off the filename and concatenate this path to my workbook reference. This didn't work, so I thought I would use the INDIRECT() function but googling more other people mentioned this does not work with closed workbooks. So I failed here, and since some of the work I am doing is using Excel automation I am instead passing this full path to the .Formula property and it does then work. Apparently, and I haven't investigated this, there is an add on called something like indirect.ext which will allow indirect to work with closed workbooks... I will try to have another look soon!
Tuesday 16 June 2009
How do you stop Excel sometime missing commas when exporting to CSV?
I have just been trying to export my spread data to a CSV. The last column of the data I have been working with does not always have a value and as a result when exporting to CSV I noticed that some rows end with a comma (the expected result when the value is blank) and others don't - even when the last value is blank... Very strange!
Thanks to some other posts out there on the web to get around this problem you need to populate the last column with a value - be it a space, a tab etc Once it contains a value the comma is then consistently applied to the csv output file - phew!
Here is a post on the Microsoft regarding this "feature" - Mircosoft support article
Thanks to some other posts out there on the web to get around this problem you need to populate the last column with a value - be it a space, a tab etc Once it contains a value the comma is then consistently applied to the csv output file - phew!
Here is a post on the Microsoft regarding this "feature" - Mircosoft support article
Sunday 7 June 2009
How do you combine a couple or more PDF files?
I just happened to need to scan and send back a non-disclosure document which I then wanted to convert to a single PDF file. Now I was using Adobe photoelements to scan the documents in and using the Save As option it is easy to save the document as a PDF. The problem that arises is I wanted one PDF instead of the two I was currently getting.
Along comes pdftk (PDF toolkit) to the rescue - see Download PDF Toolkit
This a command line tool which does a lot more than just allow the concatenation of PDF but for todays blog I just wanted to pass on how I merged two source pdfs into one:
Ok, so you need to extract the pdftk.exe from the zip file downloaded from the link above. Open up a command prompt (oh yes and I am assuming you are running this on Windows). Navigate to the folder with the pdftk.exe in it.
Now in my example I had two pdf files - non_disclosure_agreement_p1.pdf and non_disclosure_agreement_p2.pdf both situated in the root of the e drive. I have just unzipped the pdftk file into my documents folder - so c:\documents and settings\steve\my documents - so my goal was to get a merged pdf in this same my document folder. Like so:
pdftk e\non_disclosure_agreement_p1.pdf e:\non_disclosure_agreement_p2.pdf cat output non_disclosure_agreement.pdf
this does the job! the cat command concatenates the two inputs, which could have been many more files. The output statement then declares the location and filename of the output file. In this case I just supplied a filename and therefore created the new file in the my documents folder. Now as you can see this was a really simple use of the tool kit.
If you run pdftk --help you get a help listing.
I have copied and pasted the help text here - which you can review the other features available:
<--HELP LISTING-->
pdftk 1.41 a Handy Tool for Manipulating PDF Documents
Copyright (C) 2003-06, Sid Steward - Please Visit: www.pdftk.com
This is free software; see the source code for copying conditions. There is
NO warranty, not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
SYNOPSIS
pdftk
[input_pw ]
[ ]
[output
[encrypt_40bit | encrypt_128bit]
[allow]
[owner_pw]
[user_pw]
[flatten] [compress | uncompress]
[keep_first_id | keep_final_id] [drop_xfa]
[verbose] [dont_ask | do_ask]
Where:
may be empty, or:
[cat | attach_files | unpack_files | burst |
fill_form | background | stamp | generate_fdf
dump_data | dump_data_fields | update_info]
For Complete Help: pdftk --help
DESCRIPTION
If PDF is electronic paper, then pdftk is an electronic staple-remover,
hole-punch, binder, secret-decoder-ring, and X-Ray-glasses. Pdftk is a
simple tool for doing everyday things with PDF documents. Use it to:
* Merge PDF Documents
* Split PDF Pages into a New Document
* Rotate PDF Documents or Pages
* Decrypt Input as Necessary (Password Required)
* Encrypt Output as Desired
* Fill PDF Forms with X/FDF Data and/or Flatten Forms
* Generate FDF Data Stencil from PDF Forms
* Apply a Background Watermark or a Foreground Stamp
* Report PDF Metrics such as Metadata and Bookmarks
* Update PDF Metadata
* Attach Files to PDF Pages or the PDF Document
* Unpack PDF Attachments
* Burst a PDF Document into Single Pages
* Uncompress and Re-Compress Page Streams
* Repair Corrupted PDF (Where Possible)
OPTIONS
A summary of options is included below.
--help, -h
Show summary of options.
A list of the input PDF files. If you plan to combine these PDFs
(without using handles) then list files in the order you want
them combined. Use - to pass a single PDF into pdftk via stdin.
Input files can be associated with handles, where a handle is a
single, upper-case letter:
=
Handles are often omitted. They are useful when specifying PDF
passwords or page ranges, later.
For example: A=input1.pdf B=input2.pdf
[input_pw ]
Input PDF owner passwords, if necessary, are associated with
files by using their handles:
=
If handles are not given, then passwords are associated with
input files by order.
Most pdftk features require that encrypted input PDF are accom-
panied by the ~owner~ password. If the input PDF has no owner
password, then the user password must be given, instead. If the
input PDF has no passwords, then no password should be given.
When running in do_ask mode, pdftk will prompt you for a pass-
word if the supplied password is incorrect or none was given.
[ ]
If this optional argument is omitted, then pdftk runs in 'fil-
ter' mode. Filter mode takes only one PDF input and creates a
new PDF after applying all of the output options, like encryp-
tion and compression.
Available operations are: cat, attach_files, unpack_files,
burst, fill_form, background, stamp, dump_data,
dump_data_fields, generate_fdf, update_info. Some operations
takes additional arguments, described below.
cat []
Catenates pages from input PDFs to create a new PDF. Page
order in the new PDF is specified by the order of the given
page ranges. Page ranges are described like this:
[[-
ber>[]]][]
Where the handle identifies one of the input PDF files, and
the beginning and ending page numbers are one-based refer-
ences to pages in the PDF file, and the qualifier can be even
or odd, and the page rotation can be N, S, E, W, L, R, or D.
If the handle is omitted from the page range, then the pages
are taken from the first input PDF.
The even qualifier causes pdftk to use only the even-numbered
PDF pages, so 1-6even yields pages 2, 4 and 6 in that order.
6-1even yields pages 6, 4 and 2 in that order.
The odd qualifier works similarly to the even.
The page rotation setting can cause pdftk to rotate pages and
documents. Each option sets the page rotation as follows (in
degrees): N: 0, E: 90, S: 180, W: 270, L: -90, R: +90, D:
+180. L, R, and D make relative adjustments to a page's rota-
tion.
If no arguments are passed to cat, then pdftk combines all
input PDFs in the order they were given to create the output.
NOTES:
* may be less than .
* The keyword end may be used to reference the final page of
a document instead of a page number.
* Reference a single page by omitting the ending page number.
* The handle may be used alone to represent the entire PDF
document, e.g., B1-end is the same as B.
Page Range Examples w/o Handles:
1-endE - rotate entire document 90 degrees
5 11 20
5-25oddW - take odd pages in range, rotate 90 degrees
6-1
Page Range Examples Using Handles:
Say A=in1.pdf B=in2.pdf, then:
A1-21
Bend-1odd
A72
A1-21 Beven A72
AW - rotate entire document 90 degrees
B
A2-30evenL - take the even pages from the range, remove 90
degrees from each page's rotation
A A
AevenW AoddE
AW BW BD
attach_files [to_page
PROMPT>]
Packs arbitrary files into a PDF using PDF's file attachment
features. More than one attachment may be listed after
attach_files. Attachments are added at the document level
unless the optional to_page option is given, in which case
the files are attached to the given page number (the first
page is 1, the final page is end). For example:
pdftk in.pdf attach_files table1.html table2.html to_page 6
output out.pdf
unpack_files
Copies all of the attachments from the input PDF into the
current folder or to an output directory given after output.
For example:
pdftk report.pdf unpack_files output ~/atts/
or, interactively:
pdftk report.pdf unpack_files output PROMPT
burst Splits a single, input PDF document into individual pages.
Also creates a report named doc_data.txt which is the same as
the output from dump_data. If the output section is omitted,
then PDF pages are named: pg_%04d.pdf, e.g.: pg_0001.pdf,
pg_0002.pdf, etc. To name these pages yourself, supply a
printf-styled format string via the output section. For
example, if you want pages named: page_01.pdf, page_02.pdf,
etc., pass output page_%02d.pdf to pdftk. Encryption can be
applied to the output by appending output options such as
owner_pw, e.g.:
pdftk in.pdf burst owner_pw foopass
fill_form
Fills the single input PDF's form fields with the data from
an FDF file, XFDF file or stdin. Enter the data filename
after fill_form, or use - to pass the data via stdin, like
so:
pdftk form.pdf fill_form data.fdf output form.filled.pdf
After filling a form, the form fields remain interactive
unless you also use the flatten output option. flatten merges
the form fields with the PDF pages. You can use flatten
alone, too, but only on a single PDF:
pdftk form.pdf fill_form data.fdf output out.pdf flatten
or:
pdftk form.filled.pdf output out.pdf flatten
If the input FDF file includes Rich Text formatted data in
addition to plain text, then the Rich Text data is packed
into the form fields as well as the plain text. Pdftk also
sets a flag that cues Acrobat/Reader to generate new field
appearances based on the Rich Text data. That way, when the
user opens the PDF, the viewer will create the Rich Text
fields on the spot. If the user's PDF viewer does not sup-
port Rich Text, then the user will see the plain text data
instead. If you flatten this form before Acrobat has a
chance to create (and save) new field appearances, then the
plain text field data is what you'll see.
background
Applies a PDF watermark to the background of a single input
PDF. Pass the background PDF's filename after background
like so:
pdftk in.pdf background back.pdf output out.pdf
Pdftk uses only the first page from the background PDF and
applies it to every page of the input PDF. This page is
scaled and rotated as needed to fit the input page. You can
use - to pass a background PDF into pdftk via stdin.
If the input PDF does not have a transparent background (such
as a PDF created from page scans) then the resulting back-
ground won't be visible -- use the stamp feature instead.
stamp
This behaves just like the background feature except it over-
lays the stamp PDF page on top of the input PDF document's
pages. This works best if the stamp PDF page has a transpar-
ent background.
dump_data
Reads a single, input PDF file and reports various statis-
tics, metadata, bookmarks (a/k/a outlines), and page labels
to the given output filename or (if no output is given) to
stdout. Does not create a new PDF.
dump_data_fields
Reads a single, input PDF file and reports form field statis-
tics to the given output filename or (if no output is given)
to stdout. Does not create a new PDF.
generate_fdf
Reads a single, input PDF file and generates a FDF file suit-
able for fill_form out of it to the given output filename or
(if no output is given) to stdout. Does not create a new
PDF.
update_info
Changes the metadata stored in a single PDF's Info dictionary
to match the input data file. The input data file uses the
same syntax as the output from dump_data. This does not
change the metadata stored in the PDF's XMP stream, if it has
one. For example:
pdftk in.pdf update_info in.info output out.pdf
[output
The output PDF filename may not be set to the name of an input
filename. Use - to output to stdout. When using the dump_data
operation, use output to set the name of the output data file.
When using the unpack_files operation, use output to set the
name of an output directory. When using the burst operation,
you can use output to control the resulting PDF page filenames
(described above).
[encrypt_40bit | encrypt_128bit]
If an output PDF user or owner password is given, output PDF
encryption strength defaults to 128 bits. This can be overrid-
den by specifying encrypt_40bit.
[allow]
Permissions are applied to the output PDF only if an encryption
strength is specified or an owner or user password is given. If
permissions are not specified, they default to 'none,' which
means all of the following features are disabled.
The permissions section may include one or more of the following
features:
Printing
Top Quality Printing
DegradedPrinting
Lower Quality Printing
ModifyContents
Also allows Assembly
Assembly
CopyContents
Also allows ScreenReaders
ScreenReaders
ModifyAnnotations
Also allows FillIn
FillIn
AllFeatures
Allows the user to perform all of the above, and top
quality printing.
[owner_pw]
[user_pw]
If an encryption strength is given but no passwords are sup-
plied, then the owner and user passwords remain empty, which
means that the resulting PDF may be opened and its security
parameters altered by anybody.
[compress | uncompress]
These are only useful when you want to edit PDF code in a text
editor like vim or emacs. Remove PDF page stream compression by
applying the uncompress filter. Use the compress filter to
restore compression.
[flatten]
Use this option to merge an input PDF's interactive form fields
(and their data) with the PDF's pages. Only one input PDF may be
given. Sometimes used with the fill_form operation.
[keep_first_id | keep_final_id]
When combining pages from multiple PDFs, use one of these
options to copy the document ID from either the first or final
input document into the new output PDF. Otherwise pdftk creates
a new document ID for the output PDF. When no operation is
given, pdftk always uses the ID from the (single) input PDF.
[drop_xfa]
If your input PDF is a form created using Acrobat 7 or Adobe
Designer, then it probably has XFA data. Filling such a form
using pdftk yields a PDF with data that fails to display in
Acrobat 7 (and 6?). The workaround solution is to remove the
form's XFA data, either before you fill the form using pdftk or
at the time you fill the form. Using this option causes pdftk to
omit the XFA data from the output PDF form.
This option is only useful when running pdftk on a single input
PDF. When assembling a PDF from multiple inputs using pdftk,
any XFA data in the input is automatically omitted.
[verbose]
By default, pdftk runs quietly. Append verbose to the end and it
will speak up.
[dont_ask | do_ask]
Depending on the compile-time settings (see ASK_ABOUT_WARNINGS),
pdftk might prompt you for further input when it encounters a
problem, such as a bad password. Override this default behavior
by adding dont_ask (so pdftk won't ask you what to do) or do_ask
(so pdftk will ask you what to do).
When running in dont_ask mode, pdftk will over-write files with
its output without notice.
EXAMPLES
Decrypt a PDF
pdftk secured.pdf input_pw foopass output unsecured.pdf
Encrypt a PDF using 128-bit strength (the default), withhold all per-
missions (the default)
pdftk 1.pdf output 1.128.pdf owner_pw foopass
Same as above, except password 'baz' must also be used to open output
PDF
pdftk 1.pdf output 1.128.pdf owner_pw foo user_pw baz
Same as above, except printing is allowed (once the PDF is open)
pdftk 1.pdf output 1.128.pdf owner_pw foo user_pw baz allow printing
Join in1.pdf and in2.pdf into a new PDF, out1.pdf
pdftk in1.pdf in2.pdf cat output out1.pdf
or (using handles):
pdftk A=in1.pdf B=in2.pdf cat A B output out1.pdf
or (using wildcards):
pdftk *.pdf cat output combined.pdf
Remove 'page 13' from in1.pdf to create out1.pdf
pdftk in.pdf cat 1-12 14-end output out1.pdf
or:
pdftk A=in1.pdf cat A1-12 A14-end output out1.pdf
Apply 40-bit encryption to output, revoking all permissions (the
default). Set the owner PW to 'foopass'.
pdftk 1.pdf 2.pdf cat output 3.pdf encrypt_40bit owner_pw foopass
Join two files, one of which requires the password 'foopass'. The out-
put is not encrypted.
pdftk A=secured.pdf 2.pdf input_pw A=foopass cat output 3.pdf
Uncompress PDF page streams for editing the PDF in a text editor (e.g.,
vim, emacs)
pdftk doc.pdf output doc.unc.pdf uncompress
Repair a PDF's corrupted XREF table and stream lengths, if possible
pdftk broken.pdf output fixed.pdf
Burst a single PDF document into pages and dump its data to
doc_data.txt
pdftk in.pdf burst
Burst a single PDF document into encrypted pages. Allow low-quality
printing
pdftk in.pdf burst owner_pw foopass allow DegradedPrinting
Write a report on PDF document metadata and bookmarks to report.txt
pdftk in.pdf dump_data output report.txt
Rotate the first PDF page to 90 degrees clockwise
pdftk in.pdf cat 1E 2-end output out.pdf
Rotate an entire PDF document to 180 degrees
pdftk in.pdf cat 1-endS output out.pdf
<--END OF FILE-->
Along comes pdftk (PDF toolkit) to the rescue - see Download PDF Toolkit
This a command line tool which does a lot more than just allow the concatenation of PDF but for todays blog I just wanted to pass on how I merged two source pdfs into one:
Ok, so you need to extract the pdftk.exe from the zip file downloaded from the link above. Open up a command prompt (oh yes and I am assuming you are running this on Windows). Navigate to the folder with the pdftk.exe in it.
Now in my example I had two pdf files - non_disclosure_agreement_p1.pdf and non_disclosure_agreement_p2.pdf both situated in the root of the e drive. I have just unzipped the pdftk file into my documents folder - so c:\documents and settings\steve\my documents - so my goal was to get a merged pdf in this same my document folder. Like so:
pdftk e\non_disclosure_agreement_p1.pdf e:\non_disclosure_agreement_p2.pdf cat output non_disclosure_agreement.pdf
this does the job! the cat command concatenates the two inputs, which could have been many more files. The output statement then declares the location and filename of the output file. In this case I just supplied a filename and therefore created the new file in the my documents folder. Now as you can see this was a really simple use of the tool kit.
If you run pdftk --help you get a help listing.
I have copied and pasted the help text here - which you can review the other features available:
<--HELP LISTING-->
pdftk 1.41 a Handy Tool for Manipulating PDF Documents
Copyright (C) 2003-06, Sid Steward - Please Visit: www.pdftk.com
This is free software; see the source code for copying conditions. There is
NO warranty, not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
SYNOPSIS
pdftk
[input_pw ]
[
[output
[encrypt_40bit | encrypt_128bit]
[allow
[owner_pw
[user_pw
[flatten] [compress | uncompress]
[keep_first_id | keep_final_id] [drop_xfa]
[verbose] [dont_ask | do_ask]
Where:
[cat | attach_files | unpack_files | burst |
fill_form | background | stamp | generate_fdf
dump_data | dump_data_fields | update_info]
For Complete Help: pdftk --help
DESCRIPTION
If PDF is electronic paper, then pdftk is an electronic staple-remover,
hole-punch, binder, secret-decoder-ring, and X-Ray-glasses. Pdftk is a
simple tool for doing everyday things with PDF documents. Use it to:
* Merge PDF Documents
* Split PDF Pages into a New Document
* Rotate PDF Documents or Pages
* Decrypt Input as Necessary (Password Required)
* Encrypt Output as Desired
* Fill PDF Forms with X/FDF Data and/or Flatten Forms
* Generate FDF Data Stencil from PDF Forms
* Apply a Background Watermark or a Foreground Stamp
* Report PDF Metrics such as Metadata and Bookmarks
* Update PDF Metadata
* Attach Files to PDF Pages or the PDF Document
* Unpack PDF Attachments
* Burst a PDF Document into Single Pages
* Uncompress and Re-Compress Page Streams
* Repair Corrupted PDF (Where Possible)
OPTIONS
A summary of options is included below.
--help, -h
Show summary of options.
A list of the input PDF files. If you plan to combine these PDFs
(without using handles) then list files in the order you want
them combined. Use - to pass a single PDF into pdftk via stdin.
Input files can be associated with handles, where a handle is a
single, upper-case letter:
=
Handles are often omitted. They are useful when specifying PDF
passwords or page ranges, later.
For example: A=input1.pdf B=input2.pdf
[input_pw ]
Input PDF owner passwords, if necessary, are associated with
files by using their handles:
=
If handles are not given, then passwords are associated with
input files by order.
Most pdftk features require that encrypted input PDF are accom-
panied by the ~owner~ password. If the input PDF has no owner
password, then the user password must be given, instead. If the
input PDF has no passwords, then no password should be given.
When running in do_ask mode, pdftk will prompt you for a pass-
word if the supplied password is incorrect or none was given.
[
If this optional argument is omitted, then pdftk runs in 'fil-
ter' mode. Filter mode takes only one PDF input and creates a
new PDF after applying all of the output options, like encryp-
tion and compression.
Available operations are: cat, attach_files, unpack_files,
burst, fill_form, background, stamp, dump_data,
dump_data_fields, generate_fdf, update_info. Some operations
takes additional arguments, described below.
cat [
Catenates pages from input PDFs to create a new PDF. Page
order in the new PDF is specified by the order of the given
page ranges. Page ranges are described like this:
[
ber>[
Where the handle identifies one of the input PDF files, and
the beginning and ending page numbers are one-based refer-
ences to pages in the PDF file, and the qualifier can be even
or odd, and the page rotation can be N, S, E, W, L, R, or D.
If the handle is omitted from the page range, then the pages
are taken from the first input PDF.
The even qualifier causes pdftk to use only the even-numbered
PDF pages, so 1-6even yields pages 2, 4 and 6 in that order.
6-1even yields pages 6, 4 and 2 in that order.
The odd qualifier works similarly to the even.
The page rotation setting can cause pdftk to rotate pages and
documents. Each option sets the page rotation as follows (in
degrees): N: 0, E: 90, S: 180, W: 270, L: -90, R: +90, D:
+180. L, R, and D make relative adjustments to a page's rota-
tion.
If no arguments are passed to cat, then pdftk combines all
input PDFs in the order they were given to create the output.
NOTES:
*
* The keyword end may be used to reference the final page of
a document instead of a page number.
* Reference a single page by omitting the ending page number.
* The handle may be used alone to represent the entire PDF
document, e.g., B1-end is the same as B.
Page Range Examples w/o Handles:
1-endE - rotate entire document 90 degrees
5 11 20
5-25oddW - take odd pages in range, rotate 90 degrees
6-1
Page Range Examples Using Handles:
Say A=in1.pdf B=in2.pdf, then:
A1-21
Bend-1odd
A72
A1-21 Beven A72
AW - rotate entire document 90 degrees
B
A2-30evenL - take the even pages from the range, remove 90
degrees from each page's rotation
A A
AevenW AoddE
AW BW BD
attach_files
PROMPT>]
Packs arbitrary files into a PDF using PDF's file attachment
features. More than one attachment may be listed after
attach_files. Attachments are added at the document level
unless the optional to_page option is given, in which case
the files are attached to the given page number (the first
page is 1, the final page is end). For example:
pdftk in.pdf attach_files table1.html table2.html to_page 6
output out.pdf
unpack_files
Copies all of the attachments from the input PDF into the
current folder or to an output directory given after output.
For example:
pdftk report.pdf unpack_files output ~/atts/
or, interactively:
pdftk report.pdf unpack_files output PROMPT
burst Splits a single, input PDF document into individual pages.
Also creates a report named doc_data.txt which is the same as
the output from dump_data. If the output section is omitted,
then PDF pages are named: pg_%04d.pdf, e.g.: pg_0001.pdf,
pg_0002.pdf, etc. To name these pages yourself, supply a
printf-styled format string via the output section. For
example, if you want pages named: page_01.pdf, page_02.pdf,
etc., pass output page_%02d.pdf to pdftk. Encryption can be
applied to the output by appending output options such as
owner_pw, e.g.:
pdftk in.pdf burst owner_pw foopass
fill_form
Fills the single input PDF's form fields with the data from
an FDF file, XFDF file or stdin. Enter the data filename
after fill_form, or use - to pass the data via stdin, like
so:
pdftk form.pdf fill_form data.fdf output form.filled.pdf
After filling a form, the form fields remain interactive
unless you also use the flatten output option. flatten merges
the form fields with the PDF pages. You can use flatten
alone, too, but only on a single PDF:
pdftk form.pdf fill_form data.fdf output out.pdf flatten
or:
pdftk form.filled.pdf output out.pdf flatten
If the input FDF file includes Rich Text formatted data in
addition to plain text, then the Rich Text data is packed
into the form fields as well as the plain text. Pdftk also
sets a flag that cues Acrobat/Reader to generate new field
appearances based on the Rich Text data. That way, when the
user opens the PDF, the viewer will create the Rich Text
fields on the spot. If the user's PDF viewer does not sup-
port Rich Text, then the user will see the plain text data
instead. If you flatten this form before Acrobat has a
chance to create (and save) new field appearances, then the
plain text field data is what you'll see.
background
Applies a PDF watermark to the background of a single input
PDF. Pass the background PDF's filename after background
like so:
pdftk in.pdf background back.pdf output out.pdf
Pdftk uses only the first page from the background PDF and
applies it to every page of the input PDF. This page is
scaled and rotated as needed to fit the input page. You can
use - to pass a background PDF into pdftk via stdin.
If the input PDF does not have a transparent background (such
as a PDF created from page scans) then the resulting back-
ground won't be visible -- use the stamp feature instead.
stamp
This behaves just like the background feature except it over-
lays the stamp PDF page on top of the input PDF document's
pages. This works best if the stamp PDF page has a transpar-
ent background.
dump_data
Reads a single, input PDF file and reports various statis-
tics, metadata, bookmarks (a/k/a outlines), and page labels
to the given output filename or (if no output is given) to
stdout. Does not create a new PDF.
dump_data_fields
Reads a single, input PDF file and reports form field statis-
tics to the given output filename or (if no output is given)
to stdout. Does not create a new PDF.
generate_fdf
Reads a single, input PDF file and generates a FDF file suit-
able for fill_form out of it to the given output filename or
(if no output is given) to stdout. Does not create a new
PDF.
update_info
Changes the metadata stored in a single PDF's Info dictionary
to match the input data file. The input data file uses the
same syntax as the output from dump_data. This does not
change the metadata stored in the PDF's XMP stream, if it has
one. For example:
pdftk in.pdf update_info in.info output out.pdf
[output
The output PDF filename may not be set to the name of an input
filename. Use - to output to stdout. When using the dump_data
operation, use output to set the name of the output data file.
When using the unpack_files operation, use output to set the
name of an output directory. When using the burst operation,
you can use output to control the resulting PDF page filenames
(described above).
[encrypt_40bit | encrypt_128bit]
If an output PDF user or owner password is given, output PDF
encryption strength defaults to 128 bits. This can be overrid-
den by specifying encrypt_40bit.
[allow
Permissions are applied to the output PDF only if an encryption
strength is specified or an owner or user password is given. If
permissions are not specified, they default to 'none,' which
means all of the following features are disabled.
The permissions section may include one or more of the following
features:
Printing
Top Quality Printing
DegradedPrinting
Lower Quality Printing
ModifyContents
Also allows Assembly
Assembly
CopyContents
Also allows ScreenReaders
ScreenReaders
ModifyAnnotations
Also allows FillIn
FillIn
AllFeatures
Allows the user to perform all of the above, and top
quality printing.
[owner_pw
[user_pw
If an encryption strength is given but no passwords are sup-
plied, then the owner and user passwords remain empty, which
means that the resulting PDF may be opened and its security
parameters altered by anybody.
[compress | uncompress]
These are only useful when you want to edit PDF code in a text
editor like vim or emacs. Remove PDF page stream compression by
applying the uncompress filter. Use the compress filter to
restore compression.
[flatten]
Use this option to merge an input PDF's interactive form fields
(and their data) with the PDF's pages. Only one input PDF may be
given. Sometimes used with the fill_form operation.
[keep_first_id | keep_final_id]
When combining pages from multiple PDFs, use one of these
options to copy the document ID from either the first or final
input document into the new output PDF. Otherwise pdftk creates
a new document ID for the output PDF. When no operation is
given, pdftk always uses the ID from the (single) input PDF.
[drop_xfa]
If your input PDF is a form created using Acrobat 7 or Adobe
Designer, then it probably has XFA data. Filling such a form
using pdftk yields a PDF with data that fails to display in
Acrobat 7 (and 6?). The workaround solution is to remove the
form's XFA data, either before you fill the form using pdftk or
at the time you fill the form. Using this option causes pdftk to
omit the XFA data from the output PDF form.
This option is only useful when running pdftk on a single input
PDF. When assembling a PDF from multiple inputs using pdftk,
any XFA data in the input is automatically omitted.
[verbose]
By default, pdftk runs quietly. Append verbose to the end and it
will speak up.
[dont_ask | do_ask]
Depending on the compile-time settings (see ASK_ABOUT_WARNINGS),
pdftk might prompt you for further input when it encounters a
problem, such as a bad password. Override this default behavior
by adding dont_ask (so pdftk won't ask you what to do) or do_ask
(so pdftk will ask you what to do).
When running in dont_ask mode, pdftk will over-write files with
its output without notice.
EXAMPLES
Decrypt a PDF
pdftk secured.pdf input_pw foopass output unsecured.pdf
Encrypt a PDF using 128-bit strength (the default), withhold all per-
missions (the default)
pdftk 1.pdf output 1.128.pdf owner_pw foopass
Same as above, except password 'baz' must also be used to open output
pdftk 1.pdf output 1.128.pdf owner_pw foo user_pw baz
Same as above, except printing is allowed (once the PDF is open)
pdftk 1.pdf output 1.128.pdf owner_pw foo user_pw baz allow printing
Join in1.pdf and in2.pdf into a new PDF, out1.pdf
pdftk in1.pdf in2.pdf cat output out1.pdf
or (using handles):
pdftk A=in1.pdf B=in2.pdf cat A B output out1.pdf
or (using wildcards):
pdftk *.pdf cat output combined.pdf
Remove 'page 13' from in1.pdf to create out1.pdf
pdftk in.pdf cat 1-12 14-end output out1.pdf
or:
pdftk A=in1.pdf cat A1-12 A14-end output out1.pdf
Apply 40-bit encryption to output, revoking all permissions (the
default). Set the owner PW to 'foopass'.
pdftk 1.pdf 2.pdf cat output 3.pdf encrypt_40bit owner_pw foopass
Join two files, one of which requires the password 'foopass'. The out-
put is not encrypted.
pdftk A=secured.pdf 2.pdf input_pw A=foopass cat output 3.pdf
Uncompress PDF page streams for editing the PDF in a text editor (e.g.,
vim, emacs)
pdftk doc.pdf output doc.unc.pdf uncompress
Repair a PDF's corrupted XREF table and stream lengths, if possible
pdftk broken.pdf output fixed.pdf
Burst a single PDF document into pages and dump its data to
doc_data.txt
pdftk in.pdf burst
Burst a single PDF document into encrypted pages. Allow low-quality
printing
pdftk in.pdf burst owner_pw foopass allow DegradedPrinting
Write a report on PDF document metadata and bookmarks to report.txt
pdftk in.pdf dump_data output report.txt
Rotate the first PDF page to 90 degrees clockwise
pdftk in.pdf cat 1E 2-end output out.pdf
Rotate an entire PDF document to 180 degrees
pdftk in.pdf cat 1-endS output out.pdf
<--END OF FILE-->
Thursday 4 June 2009
How do you use a .NET XMLDocument SelectNodes and the default namespace?
I have just been trying to load an XML document into a .NET XMLDocument and then use the SelectNodes method passing an XPath string to get a XMLNodeList in return. Easy so I thought! The XML being loaded did have a default namespace, and as such all the elements within it did not have any namespace references... and equally therefore I assumed that my XPath query would not need any namespace prefix especially since the XML loaded had none. Alas, my code didn't work!
The solution, and of course easy when you know how, is to use an XMLNamespaceManager object and add a reference to your default namespace (or any other namespaces used within your document) but the key thing is to add a prefix - it does not matter than the source XML isn't using prefixes. My initial thought was to just add the namespace again without a prefix - nope, this doesn't work! No, once you add the namespace with prefix, and then pass the namespace manager object as a parameter in your SelectNodes call plus your newly prefixed xpath query and you will find delightedly you have some result nodes!!
An example...
//So key to note that the lcw namespace is the default namespace in my XML file it has no prefix in the file - but here it not associated with the prefix lcw
xmlSupplierMap = new XmlDocument();
namespaceMan = new XmlNamespaceManager(xmlSupplierMap.NameTable);
namespaceMan.AddNamespace("lcw", http://www.defaultnamespace.domain/blah);
xmlSupplierMap.Load("filename of xml.xml");
//My new XPath query uses the prefix assigned previously lcw: and bingo we get data!
XmlNodeList worksheetNodelist = xmlSupplierMap.SelectNodes("lcw:worksheet", namespaceMan);
The solution, and of course easy when you know how, is to use an XMLNamespaceManager object and add a reference to your default namespace (or any other namespaces used within your document) but the key thing is to add a prefix - it does not matter than the source XML isn't using prefixes. My initial thought was to just add the namespace again without a prefix - nope, this doesn't work! No, once you add the namespace with prefix, and then pass the namespace manager object as a parameter in your SelectNodes call plus your newly prefixed xpath query and you will find delightedly you have some result nodes!!
An example...
//So key to note that the lcw namespace is the default namespace in my XML file it has no prefix in the file - but here it not associated with the prefix lcw
xmlSupplierMap = new XmlDocument();
namespaceMan = new XmlNamespaceManager(xmlSupplierMap.NameTable);
namespaceMan.AddNamespace("lcw", http://www.defaultnamespace.domain/blah);
xmlSupplierMap.Load("filename of xml.xml");
//My new XPath query uses the prefix assigned previously lcw: and bingo we get data!
XmlNodeList worksheetNodelist = xmlSupplierMap.SelectNodes("lcw:worksheet", namespaceMan);
Subscribe to:
Posts (Atom)