Frequently Asked Questions Section
14 Jul 20257 minutes to read
The frequently asked questions in Essential® XlsIO are listed below.
- How to open an existing XLSX workbook and save it as XLS?
- How to open an Excel file from stream?
- How to save a file to stream?
- How to create and open Excel Template files by using XlsIO?
- How to open an Excel 2013 Macro Enabled Template?
- How to change the grid line color of the Excel sheet?
- How to copy/paste the cell values that contain only formula?
- How to copy a range from one workbook to another?
- How to merge excel files from more than one workbook to a single file?
- How to ignore the green error marker in worksheets?
- How to protect certain cells in a worksheet?
- How to set a line break inside a cell?
- How to set or format a Header/Footer?
- How to set print titles?
- How to unfreeze the rows and columns in XlsIO?
- What is the maximum range of Rows and Columns?
- How to use Named Ranges with XlsIO?
- How to add chart labels to scatter points?
- How to create a Chart with a discontinuous range?
- How to define discontinuous ranges?
- How to create a sparkline from a named range?
- How to format text within a cell?
- How to hide the summary rows and columns using XlsIO?
- How to sort two or more columns in a pivot table?
- How to import data table with its data type using template markers?
- How to zip files using the Syncfusion.Compression.Zip namespace?
- How to zip all the files in subfolders using Syncfusion® Compression?
- How to protect the zip files using Syncfusion.Compression.Base?
- How to un-protect the zip files using Syncfusion.Compression.Base?
- Does Essential® XlsIO provide support for Client Profile?
- How to resolve the File does not contain workbook stream error in Syncfusion.XlsIO.Base.dll?
- How to resolve Excel cannot open the file filename.xlsx… error?
- How does Excel file with uninstalled fonts is converted to PDF/Image?
- How to avoid exception when adding worksheets with same name?
- How to change data point label color of a Waterfall chart?
- How to check whether an Excel document contains macro?
- Does XlsIO support password protected macro in the Excel documents?
- Does XlsIO support Excel files with macros that are digitally signed?
- How to overcome StackOverflow exception with IWorksheet Calculate()?
- How to overcome UnauthorizedAccessException?
- How to ignore print areas set in a worksheet?
- In which situation we use AutoDetectComplexScript converter property?
- What is the image quality when using the ExportQualityImage property?
- How to open an Excel document using XlsIO that is already open in MS-Excel?
- Reason for Parameter Not Valid exception when converting Excel to PDF with Custom Paper Size
- Information about maximum characters count in an Excel cell
- How to find values with a matching case for specific column in Excel?
- Does XlsIO support working with Excel files in .NET 6.0?
- How to convert the required range in Excel to PDF?
- How to search a value in only specific columns of an Excel worksheet?
- How to read filtered rows in Excel?
- What are the deprecated APIs in XlsIO?
- How to detect merged cells in Excel?
- How to apply formatting to pivot table in Excel protected view?
- Does XlsIO library support multithreading and thread-safe?
- How to check whether the given range is valid or not?
- How to convert hidden worksheets alone to image?
- How to find and highlight data in Excel?
- How to avoid header row while sorting Excel data?
- How to edit external workbook reference link?
- How to set error bars in chart?
- Migrate XlsIO library from .NET Framework to .NET Core?
- How to apply rotation and transparency to background image?
- How to open an Excel file with encoding in .NET Core?
- How to convert image from URL in Excel to PDF?
- How to change the shape text font?
- Why cone chart shows itself as column or bar chart?
- How to vary colors by point for line and column chart?
- How to upload a file to Azure blob and download as stream?
- How to find and replace text in hyperlinks?
- How to fix the ArgumentOutOfRangeException when accessing a large number of rows and columns?
- How to set Logarithmic axis for chart in Excel document?
- How to resolve performance issue when deleting a large number of rows?
- How to hide columns using column name?
- How to convert xls document to xlsx format document?
- How to access a table in Excel document using the table name?
- How to check whether the loaded file is an Excel file?
- How to insert a picture into a cell in an Excel document?
- How to get the RGB color value for the applied cell color?
- How to convert a value from pixel to points with scaling percentage?
- How to save the edited changes in the same Excel document?
- How to get the frozen rows and columns in an Excel document?
- How to find duplicate values in the Excel document using formulas?
- How to protect zip file items with different passwords using C#?
- How to extract and save images from an Excel worksheet
- How to delete blank rows and blank columns in an Excel worksheet using C#?
- How to retain cell values after removing formulas in Excel?
- How to remove data validation from the specified range?
- How to remove autofilter from an Excel worksheet?
- How to convert an Excel worksheet to a high-resolution image?
- How to add and remove page breaks in a worksheet?
- How to decrypt individual items with specific passwords?
- What is the behavior of FitToPagesTall and FitToPagesWide?
- How to use AND and OR operators in the filter?
- Why out of memory exception is thrown when handling large documents which is having size more than 2GB?
- Does XlsIO support the multiline header footer support?
- How to add Barcode in Excel document using C#?
- How to delete hyperlinks from a worksheet without affecting the cell styles using C#?
- How to avoid processing unnecessary worksheets when opening an Excel document using C#?
- How to run macros in Excel document?
- Does XlsIO support editing an Excel document that is already open in Microsoft Excel?
- How to compute the size of the Excel file?
- How to set and format time values in Excel using TimeSpan?
- How to set the default font and font size in an Excel Workbook?
- How to set traffic lights icon in Excel conditional formatting using C#?
- How to apply TimePeriod conditional formatting in Excel using C#?
- How to get the list of worksheet names in an Excel workbook?
- How to switch chart series data interpretation from horizontal (rows) to vertical (columns) in Excel?
- How to add Oval shape to Excel chart using XlsIO?
- How to show the leader line on Excel chart?
- How to set the background color for Excel Chart in C#?
- How to override an Excel document using C#?
- Does XlsIO support converting an empty Excel document to PDF?
- What is the maximum supported text length for data validation in Excel?
- How to set column width for a pivot table range in an Excel Document?
- How to convert JSON document to CSV format document?