This article describes how to use HeSoft Doc Batch Tool batch convert multiple Excel spreadsheet files to XPS format. It is suitable for office scenes that require unified archiving, fixed layout and sending files that cannot be easily edited. The article combines the software interface steps to explain the complete process from selecting the "Excel to XPS" function, adding xlsx files, setting the page display mode, selecting the save location to starting the process, helping users to reduce the repeated operations of opening Excel and saving it as XPS one by one.
In daily office, if you need to convert multiple Excel tables into XPS format, opening files one by one and saving them as XPS is not only time-consuming, but also easy to miss files. Especially when financial statements, statistical ledgers, project lists, data summaries and other documents need to be archived in a fixed format or sent to the outside world, batch processing will be more efficient. This article will introduce how to use office software" HeSoft Doc Batch Tool "to convert multiple Excel table files into XPS format at one time, which is suitable for batch conversion requirements of Excel files such as. xlsx.
Application scenario: When do you need to convert Excel to XPS in batches
Excel to XPS is common in office scenes that need to fix document format, reduce content modification at will, and facilitate unified filing. For example, the department needs to save multiple Excel reports in a fixed format at the end of the month. Administrative or financial personnel need to organize the form files into a unified XPS file. When project data is delivered, multiple xlsx forms need to be converted into a format that is easy to view and retain.
If the number of files is small, manual conversion is acceptable, but when the number of files reaches dozens or more, the use of batch processing tools can significantly reduce duplication of operations. HeSoft Doc Batch Tool The positioning of is the batch processing of office files, which helps users import multiple files at a time, set conversion options uniformly and output results centrally through process-based operations.
Effect preview: Excel file before processing, XPS file generated after processing
from the example effect, the pre-processing folder contains multiple Excel spreadsheet files, for example:
- 01.xlsx
- 02.xlsx
- 03.xlsx
- 04.xlsx
- 05.xlsx
after the batch conversion is completed, the corresponding XPS file will be obtained, for example:
- 01.xps
- 02.xps
- 03.xps
- 04.xps
- 05.xps
in other words, the software will generate corresponding XPS format files one by one according to the original Excel files, which is convenient for users to view, distribute or archive later.
Step 1: Enter the Excel tool and select "Convert Excel to XPS"
open HeSoft Doc Batch Tool select Excel Tools in the left feature category ". The interface will display multiple batch processing functions related to Excel, such as converting Excel to JPG pictures, converting Excel to Word, and converting Excel to PDF.
Locate and click "Convert Excel to XPS" in the list of features ". The function description is "Batch convert Excel files to XPS format", which is consistent with the batch conversion requirements to be addressed in this article. After entering this function, the software will enter the step-by-step processing interface. At the top, the process can be seen as "Select Records to Process", "Set Processing Options", "Set Saving Location" and "Start Processing".
Step 2: Add the Excel file to be converted
after entering the "Convert Excel to XPS" function, you first need to select the Excel file to be processed. The top right of the interface provides "add files" and "import files from the folder" two common entry.
- If you only need to select some Excel files, you can click "Add File" to manually select the files to be converted.
- If all Excel tables to be converted have been sorted out in a folder, you can click "Import Files from Folder" to import the files in the folder at one time.
After a file is added, information such as serial number, name, path, extension, creation time, and modification time is displayed in the list. In the example, five files including 01.xlsx, 02.xlsx, 03.xlsx, 04.xlsx, and 05.xlsx have been imported. Users can check whether the files are correct through the list and avoid adding tables that do not need to be converted to tasks.
If you imported the wrong file, you can use the delete icon to the right of each line to remove it; if you need to reselect, you can also use the "Clear" button to clear the current list. At the top of the list, operations such as "filtering" and "sorting" are also provided to facilitate sorting when there are many files. After confirming that the file is correct, click "Next" at the bottom ".
Operation step 3: set the page display mode of Excel to XPS
after entering the second step "Set processing options", you can configure the page display mode when converting to XPS. The following options are available in the screenshot:
- Excel layout settings shall prevail: conversion shall be carried out according to the page layout settings in the original Excel file, which is suitable for files with printing area, paper direction, paging and other contents already set in Excel.
- Each work form has a single page: suitable for scenarios where you want to output pages by worksheet, so as to maintain a clear distinction between different sheets.
- Priority is given to ensuring that all columns are on the same page: suitable for tables with a large number of columns, and more attention is paid to displaying horizontal column contents on the same page as much as possible during conversion.
The Automatically Resize Cell Row Height option is also available in the interface. After opening, the software will adjust the row height according to the table content during the conversion process, which is suitable for tables with more content and incomplete display. Users can decide whether to enable the form according to the layout requirements.
If you are not sure how to choose, you can usually use "Excel layout settings" first, which can more closely match the layout of the original Excel file. When the settings are complete, click Next ".
Step 4: Set the Save Location of the XPS File
the third step is "set save location". In this step, follow the software interface prompts to select the output directory of the converted XPS file. It is recommended to choose a separate folder to save the results, such as "Excel to XPS Output" or "XPS Archive File", which can prevent the converted file from mixing with the original Excel file.
The purpose of setting the save location is to let the software know where the batch generated. xps files should be stored. For batch conversion tasks, planning the output directory in advance also facilitates subsequent inspection of conversion results, packaging and sending, or unified archiving.
Step 5: Start batch processing and check the results
after setting the save location, proceed to the "Start Processing" step. After confirming the number of files to be processed, the processing options, and the save path are correct, start the conversion task. The software will process the Excel files in the list one by one and generate the corresponding XPS file.
After processing, open the output folder to check. Under normal circumstances, the original 01.xlsx, 02.xlsx, and 03.xlsx files will generate result files such as 01.xps, 02.xps, and 03.xps respectively. It is recommended to focus on checking whether the number of files is consistent, whether the file names correspond, and whether the format after opening meets expectations.
Frequently Asked Questions and Precautions
1. Do I need to organize Excel files before conversion?
It is recommended to put the Excel table to be converted in the same folder first, and keep the file name clear, for example, by serial number, date or project name. This makes it more convenient to use Import Files from Folder and to check XPS files after conversion.
2. How should the page be displayed?
If the Excel file itself has already set the print layout, select "Excel layout settings shall prevail" first ". If you want each worksheet to render independently, you can select One page per work form ". If there are many columns in the table and you are worried that the horizontal content will be disassembled after conversion, you can try to "give priority to ensuring that all columns are on the same page".
3. Why should I check the converted XPS file?
The display effect of Excel table is related to the column width, row height, paging and worksheet layout in the original file. After the batch conversion is completed, it is recommended to spot check several result documents to confirm that the content is complete and the page layout meets the requirements, especially for documents that are officially filed or sent to the outside.
4. How to improve efficiency when there are many documents?
You can organize the original Excel files by folder first, and then use "Import Files from Folder" to add them in batches. After import, check the name and path through the list, and use "Filter" and "Sort" to assist in checking if necessary. This is more stable and time-saving than opening Excel individually and saving as XPS manually.
Summary: Reduce repetitive operations from Excel to XPS with batch processing tools
batch conversion of Excel table files into XPS format is essentially to hand over the repeated "open file, format and save as" process to office software for unified completion. By HeSoft Doc Batch Tool , users only need to select the "Excel to XPS" function, import Excel files such as. xlsx, and set the page display mode and save location to generate the corresponding XPS file.
For office workers who often deal with reports, ledgers, lists and archived data, this type of batch conversion function can significantly save time and reduce omissions and misoperations. It is suggested that the next time you need to batch convert Excel to XPS, first organize the files into the same directory, and then complete the conversion according to the steps in this article to improve the overall office efficiency.