C WHAT ARE THE MORE THAN A DOZEN ATTRIBUTE PARAMETERS IN THE SAVE EXCEL METHOD? After solving, anoth

Just one filename is all you need, and the rest is a type of variable!

Try this static field.

It is not advisable to pass the value of the session because the session exists on the server side, and even if the web page is closed, the session will still occupy the server's memory and will not be released until the session expires (or you release it manually).

As for the maximum number of characters that can be saved, a few megabytes should be no problem.

Session values should be used sparingly.

In the initial stage, use URL to transmit stable and easy to use, and write a small encryption yourself if necessary

In the advanced stage, you can change the httpcontext to implement value transfer

You don't have to worry about the size of the session, you can save as much as you want.

If there is no merged cell, it is easier to export to excel The method is: traversing the table to process the data in the table to the datatable type or other types in the background, and export the file in the background, you can refer to it.

Exporting to Word is more complicated, you can refer to it.

If it's not a confidential file, you can pass it to me, I'll help you modify, the basic method is: rebuild an excel document, then copy the data area, paste into the new document, (be careful not to select all - copy, otherwise the copy is still the same size in the past), and then change the format is OK, the principle is, maybe some other blank places you also added the format, resulting in this is also considered to be the data recorded in the document, so the document becomes bigger!

It's basically excel poisoning.,Look at the problem below.,It's the same symptom.,But it's not solved.,Hey.。

I think it's malware! He put the virus program in your excle and caused it to increase its capacity!! So the software is completely destroyed!! You can only do it again, by the way, do an antivirus on the computer, or save an attachment to the USB flash drive after you are done!!

Send me your excel and I'll show you.

Save the xls file as cvs format, open the cvs file, save as xls file, and you're good to go.

Mobo, update MS06-040 security update. This time it's the same as the previous shockwaves, oscillating waves, and sniper waves. Originated from a vulnerability attack, please update the patch.

If you have a virus, it is recommended that you clean up your computer system by updating the patch.

Select all first, copy it into a new worksheet, and delete the original worksheet.

Poisoning! Bound by another file!

Antivirus!

Delete the text first, re-enter it, and you're good to go.

Try to delete all the lines after the last valid line.

Save As to re-establish the file name.

See if there are any hidden files.

3. Right-click on the name of the [January of the Marketing Department] form in the Excel of the Marketing Department, and click [Move or Copy] in the dialog box that appears, and the [Move or Copy Worksheet] dialog box will pop up, as shown in the figure.

4. In the [Move or Copy Worksheet] dialog box, select [Planning] for the workbook, select [Move to Last] for the position, tick the box in front of [Create Copy], and then click the [OK] button, as shown in the figure.

Landlord, you can use the copy of the file to copy the operation:

e:\aaa\", @"e:\bbb\");

The example above is to copy the following from e: aaa to the following to the following e: bbb and name it.

Good luck, don't understand can be discussed.

If you enter it, you can change it.

1. Set the cell range you want to input to text format before entering.

2. Enter a single quotation mark and then enter a number.

Excel regular numbers can only be read 15 for, the ID card will have the last 3 digits as zero, and the solution has 2

First: Format the cell as "Text" before input

Second: Enter single quotation marks in English first, and then enter the number.

There are two methods, first, select the cell area to enter multiple digits - cell settings - number - text - OK; 2. Enter before entering the number".'(double quotation marks in English), and then enter the number.

What has changed, is not changed back, because of the scientific count, will discard the number after 14 digits, you have to find a way to undo (if you haven't closed the file yet), or find a backup file (if you used to open it for more than 10 minutes) to recover.

To re-enter, change the cell formatting to text (right-click on the selected cell, Cell Properties-General-Text) and enter it, or enter an English quotation mark () before entering the ID number'）

Precede the number with a single quotation mark '

Select the cell to format the cell Format the number as text and re-enter it.

In daily work, when using Excel, you can see the relevant information of the author of the Excel document, and if you want to remove the information, you can delete the personal information when saving, so that other users can misunderstand when using it. Here's how to delete personal information from file attributes when saving in Excel.

2. After setting, please click "Microsoft Office Button", click "Other Commands" and the "Excel Options" dialog box will pop up (as shown in the figure).

3. On the left side of the pop-up Excel Options dialog box, click the Trust Center command, and in the right box that appears, Microsoft Office Excel Trust Center.

4. In the option box on the right, click the "Trust Center Settings" button.

5. In the "Personal Information Options" category on the page that appears, clear the check box for the "Delete personal information in document properties when saving" option.

6. Click the "OK" button again, and then click the "OK" button to exit the "Excel Options" dialog box.

7. The page returns to the worksheet, click the "Save" button and close the excel document.

8. Then find the saved excle document in the path you just saved, and right-click "Properties" to see if there is any personal information. If you haven't deleted it yet, go back to "Step 5", click "Document Checker", click "Check", and then click "Delete" the document attributes and personal information.

9. The personal information in the file attributes was deleted.

Tools - Options - Security, and remove the Delete Personal Information checkmark in front of it. This usually occurs after the macro has been set.

Some malicious macros will be harmful, that is, viruses, but very few, because this virus is too low-level, and people don't bother to do this. At least I've never encountered one, and I've never forbidden macros to run.