Spreadsheet Tools
XLSB to PDF Ruby Overview
Convert Excel XLSB workbooks to PDF for sharing, review, and archiving. Select the worksheet by name, index, or the active sheet, and open password‑protected files when required. Control page orientation and page size, auto‑fit by columns or pages, clear print areas, and apply custom scaling to match layout constraints. Add a header on each page and optionally preserve metadata. Normalize locale with thousands/decimal separators and date formats for consistent output. Enable PDF/A for long‑term preservation and process single files or batches with predictable results.
Lightning Fast Conversions
Process and convert files in seconds with our high-performance cloud infrastructure.
Accuracy Guaranteed
Our advanced algorithms ensure pixel-perfect and content-accurate file conversions.
Enterprise-Grade Security
ISO 27001, HIPAA, and GDPR compliant with encrypted file processing.
Global Infrastructure
Strategically located servers ensure low latency and high availability worldwide.
Developer Friendly
Comprehensive SDKs and clear documentation for quick and simple integration.
Time-Saving Automation
Automate repetitive document workflows and focus on what matters most.
Customizable Parameters
Fine-tune your automation with these powerful conversion options
File
File Supported formats: .xlsbFile to be converted. Value can be URL or file content.
Password
StringSets the password to open protected documents.
WorksheetActive
Bool Default: FalseSet to convert active worksheet. If value is set False all worksheet will be converted.
WorksheetIndex
IntegerSet worksheet index(number) to convert. If value is not set all worksheet will be converted.
Range: 1 .. 2000WorksheetName
StringSet worksheet name to convert. If value is not set all worksheet will be converted.
ConvertMetadata
Bool Default: TrueConvert document metadata like Title, Author, Keywords to PDF metadata.
PageOrientation
Collection Default: defaultPage orientation.
Values: default portrait landscapePageSize
Collection Default: defaultPage size.
Values: default letter lettersmall tabloid ledger legal statement executive a3 a4 a4small a5 b4 b5AutoColumnFit
Bool Default: FalseAuto fit columns to reduce unnecessary empty space in table.
AutoPageFit
Bool Default: FalseAutomatically enlarges page size, switches to landscape when needed, trims margins, and finally scales the sheet to one-page width. If PageSize or PageOrientation are chosen, those choices are left unchanged.
ClearPrintArea
Bool Default: FalseClear the print area in the converting document.
Scale
IntegerSet content scale value in percentage.
Range: 10 .. 300HeaderOnEachPage
Bool Default: FalseEnsures the header row is repeated on all pages when the sheet's content spans multiple pages in the PDF output. If a table is detected in the sheet, its header row is used; otherwise, the first row with data is treated as the header.
ThousandsSeparator
String Default: ,Thousands separator.
DecimalSeparator
String Default: .Decimal separator.
DateFormat
Collection Default: usSets the date format for output document, overriding the default US locale (M/d/yyyy) to ensure consistency regardless of regional Excel settings.
Values: us iso eu german japanesePdfa
Bool Default: FalseCreate PDF/A-1b compliant document.
StoreFile
Bool Default: FalseWhen the StoreFile parameter is set to True, your converted file is written to ConvertAPI’s encrypted, temporary storage and made available via a time-limited secure download URL, valid for up to 3 hours. After this period, the file is permanently deleted.
When StoreFile is set to False, conversion happens entirely in-memory. The raw file bytes are streamed back in the API response without touching disk or external storage, ensuring maximum security and zero persistence so that only you can access the content.
Step-by-Step Guide
Easy XLSB to PDF integration programmatically using our Ruby GEM
1. ConvertAPI Ruby library install
ConvertAPI provides a Ruby Gem that allows you to perform a XLSB to PDF conversion with just a few lines of code. First, install the ConvertAPI Ruby SDK:
Add this line to your application's Gemfile:
gem 'convert_api'
2. Authenticate your Ruby library
You can obtain your API Token by signing up for a free account. Once you sign up, you'll receive 250 free conversions instantly! Grab your API Token from the account dashboard, and authenticate the ConvertAPI Ruby library like this:
# get your API Token here: https://www.convertapi.com/a/auth
ConvertApi.configure do |config|
config.api_credentials = 'api_token'
end
3. Convert XLSB to PDF using Ruby in no time!
Once you have your authentication in place, simply copy-paste this xlsb to pdf conversion code snippet into your Ruby project:
Integrate within minutes
Easy XLSB to PDF automation using our simple Ruby SDK
Compatible With all Ruby Frameworks & Tools
Businesses trust us
Highest rated File Conversion API on major B2B software listing platforms: Capterra, G2, and Trustpilot.
"ConvertAPI has been a game-changer for our document automation workflows. Their conversion accuracy and API reliability are unmatched in the industry for over 7 years."
"ConvertAPI is a reliable, cost-effective solution with a proven track record of stability. It has grown significantly in maturity, adopting enterprise-grade practices over the years."
"We've integrated ConvertAPI across our entire document processing platform. The performance is exceptional and the support team is always responsive. Highly recommended!"
Enterprise-Grade Security
We ensure that all document processing is handled securely in the cloud, adhering to industry-leading standards like ISO 27001, GDPR, and HIPAA. To enhance security even further, we can ensure that no files or data are stored on our servers and never leave your country.
Learn more about security