I have an article in the 24th issue of Vckbase Online magazine, "A report class library similar to Excel." The example program in this article has the latest version, the screenshot of the screen and the contents of the document have been updated. Please download the latest program from the link at the top of this article.
20030907 Update content:
1 start to support chart display in the program
2 Modify
Create a PivotChart report in an Excel table
Steps
1, open the data document in Excel, this data is 2013-2014 3 Sales staff expense reimbursement situation.
2, click any cell in the data range, click "Insert", find the "pivot table" chart, and click "PivotChart".
3, in the pop-up window, select the area of the data to be analyzed, sele
When you use Excel as a report, you might want to manipulate cell borders and fill colors and textures, and the following code shows how to set the fill texture and border of a selected cell.
try {thisapplication = new Excel.Application (); ThisWorkbook = ThisApplication.Workbooks.Open ("Z:\\book1.xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type
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.