Modify the digital output format.
'| NVL (L_H.E_NUMBER,' & nbsp ') |
'
If you want to output the ID card number in BI Pulbisher report Excel and do not display the scientific notation, you can modify the defined rtf template as follows:
Find the ID
Export the data from the JSP page to the Excel table, which is for informational purposes only. (the "Graduate Information Inquiry" project written in the Junior training program)
1. Generate Excel Templates
1 Create a new Excel file (template. xls),
In doing the project, encounter title problem. For example, to export resident information to Excel, the resident's ID number is too long (greater than 10 digits), and Excel automatically converts an excessive number string into scientific notation.
Rewrite the defaults with $.fn.tree.defaults.
Depend on
Draggable
Droppable
Usage
The tree can be defined in the
Copy Code code as follows:
Folder
sub Folder 1
file 11
file 12
file 13
Ucs2 format in SIM card
The text in the SIM card is stored in the ucs2 format. ucs2 and Unicode are only in different byte order, Unicode is a small header, and ucs2 is a big header.
The widechartomultibyte and multibytetowidechar functions in VC
Response. contenttype = "application/vnd. MS-excel" 'sets the webpage output type to excel.%>
Field 1 Field 2 Field 3 Field 4
MSO-number-format: "0" No DecimalsMSO-number-format: "0 \. 000" 3 DecimalsMSO-number-format: "\#\,\#\# 0 \.
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.