Six first-aid solutions for excelxp damaged files

Source: Internet
Author: User
Excelxp files damaged six strokes of first aid careful, careful, and careful, but still can not avoid excelxp files damaged, then do you discard the damaged files, or find a way to first aid? If it belongs to the latter type, you will be pleasantly surprised by the following content.

1. Conversion format

This method re-Saves the damaged excelxp workbook and selects the Save format as the sylk format. In general, if you can open the damaged excelxp file, if you cannot edit or print files, we recommend that you first try this method to convert the damaged excelxp workbook to the sylk format for storage, in this way, you can filter out the damaged parts in the document.

2. Direct repair

The latest version of excelxp provides the function of directly repairing damaged files. You can use the "open and fix" command added by excelxp to directly check and fix errors in excelxp files. Just click this command, excelxp opens a repair dialog box. Click the repair button in the dialog box. This method is often suitable for situations where the damaged file cannot be opened using the conventional method.

3. Column stealing

When the damaged excelxp file cannot be opened, you can try to use the wordProgramTo open an Excel file, this method is achieved by using the word to directly read an Excel file, which is usually applicable to the absence of damage to the excelxp file header, the following is the specific operation steps:

(1) run the word program and select the Excel file to be opened in the displayed file opening dialog box;

(2) If you use the word program to open the excelxp file for the first time, you may see that "Microsoft Word cannot import the specified format. This feature is not yet installed. Are you sure you want to install it now ?" In this case, you can insert a Microsoft Office installation disk to complete the installation task of this function;

(3) The Word program will prompt you whether to select the entire workbook or a worksheet. You can select the type of the file to be restored;

(4) After opening the damaged file, you can delete the damaged data in the file and move the cursor to the table, in the menu bar, execute the "table", "convert", and "Convert table to text" commands in sequence;

(5) In the subsequent dialog box, select the tab as the text separator to convert the table content into text content;

(6) execute the "file"/"Save as" command in sequence in the word menu bar to save the converted text content as a plain text file;

(7) run the excelxp program to run the "file"/"open" command. In the displayed file dialog box, select "text file" or "all files" as the text type ", in this way, you can open the saved text file;

(8) Then you will see a text import wizard setting box. As long as you can open the file as prompted, you will find that the content of the worksheet is exactly the same as that of the original worksheet, the difference is that all formulas in the table need to be reset, and some text and number formats are lost.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.