Print a CSV stock table without losing identifiers
Admin ·
A stock table needs a printable version for the warehouse without changing the way each bin code is written. Make the table searchable and check that the values fit at the page size you need.
Prepare the stock table in A4 landscape
Select Load example and check that Separator is Comma. Keep A4 and Landscape, then select Prepare PDF preview. Read the station name Café, east as one cell. The notes show the quotation marks in Hold “dry” as literal characters.
Look for both bin codes, 00427 and 12345678901234567. Select Print or save PDF and choose Save as PDF. Search the saved file for either complete code.
Repeat the headers on later pages
To test a longer report, paste the stock row repeatedly underneath the header. Keep Use first record as repeating header selected. The in-page preview shows up to 24 data rows. Use the print preview to inspect the actual page breaks.
Print on A4 landscape with the default margins and turn off the browser’s date and URL headers. On a later page, find Station and Bin identifier above the data rows.
Check a quoted field before changing the separator
In the example, the comma between Café and east lies inside double quotes. Keep Comma selected for this example. When the source uses tabs or semicolons, change Separator and prepare the preview again.
Common questions
Is the PDF created from a screenshot of the table?
The browser prints the cells as searchable text. Select a code in the saved PDF to verify it.
What should I change when the table is too narrow?
Use landscape orientation, a smaller text size or narrower margins, then check the print preview again.