Convert Selected or Partial Spreadsheet Rows

Share on FacebookTweet about this on TwitterShare on LinkedIn

You might be looking for a software component or API using that an excel sheet could be converted to PDF/Word or any other supported format partially.

What is the difference?
Many of us are just concerned with the output. Process an excel spreadsheet and get the right PDF/output. A simple conversion (Complete spreadsheet to PDF) is ideal until the source file has limited number of rows.

Partial Conversion – Usability

If you have a spreadsheet with more than 10,000 rows and your data or concerned rows are somewhere between 5,000 to 8,000. Wouldn’t you prefer to get PDF of rows 5,000 to 8,000 only?
This is useful because:

  • Fast and to the point conversion
  • Less resources consumption
  • Easy to define conversion range

Let’s have a look at the implementation:
C#
https://gist.github.com/8fcd5ac07b9c59c76ce7f439cd871455″>Gist.
Java
View the code on <a href="https://gist.github.com/ba33c892e92dc3332bf77ada945b2cbd
“G7:I10” is the cells range (convert from row G7 to I10). Below are the screenshots of source and output files.

API allows you to set sheet/page number to convert using PageNumber property. For example you have an Excel file with 10 sheets. You can easily convert from G7 to I10 on page 6.

Download GroupDocs.Conversion API and try out this feature. Below are some helpful resources:

The post Convert Selected or Partial Spreadsheet Rows appeared first on Document Manipulation APIs Blog – groupdocs.com.