DsExcel Java enables you to manage all the file operations without any hassle.
Users can import (open) files with different formats including .xlsx, .xlsm, .xltx, .csv, .json, and .sjs files. Also, you can export (save) data from a workbook into several formats including .xlsx, .csv, .pdf and .json files into DsExcel Java. Further, you can choose to save the whole component, a specific sheet or data chunks from a particular cell range to different file types or output streams based on your requirements.
Shared below are some common ways to execute file management operations for a range of file types in DsExcel Java:
Note: While exporting a worksheet to PDF, HTML or image file formats, you can set the HorizontalAlignment enumeration to CenterContinuous to center align the text across multiple cells. However, the horizontal alignment should be set before merging the cells. Otherwise, the cells may be drawn incorrectly in exported file formats.
