轉(zhuǎn)帖|使用教程|編輯:龔雪|2016-12-23 13:12:01.000|閱讀 2789 次
概述:簡單介紹一些關(guān)于DevExpress Spreadsheet常用的片段。
# 界面/圖表報表/文檔/IDE等千款熱門軟控件火熱銷售中 >>
1) 在Spreadsheet中創(chuàng)建或修改樣式
1. // Add a new style under the "My Style" name to the Styles collection of the workbook.
2. Style myStyle = workbook.Styles.Add("My Style");
3. // Specify formatting characteristics for the style.
4. myStyle.BeginUpdate();
5. try {
6. // Set the font color to Blue.
7. myStyle.Font.Color = Color.Blue;
8. // Set the font size to 12.
9. myStyle.Font.Size = 12;
10. // Set the horizontal alignment to Center.
11. myStyle.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
12. // Set the background.
13. myStyle.Fill.BackgroundColor = Color.LightBlue;
14. myStyle.Fill.PatternType = PatternType.LightGray;
15. myStyle.Fill.PatternColor = Color.Yellow;
16. }
17. finally {
18. myStyle.EndUpdate();
19. }
2) 訪問列(Row)或者行(Column)
行:
1. using DevExpress.Spreadsheet; 2. // ... 3. Workbook workbook = new Workbook(); 4. // Access a collection of rows. 5. RowCollection rows = workbook.Worksheets[0].Rows; 6. // Access the first row by its index in the collection of rows. 7. Row firstRow_byIndex = rows[0]; 8. // Access the first row by its unique name. 9. Row firstRow_byName = rows["1"];
列:
1. using DevExpress.Spreadsheet; 2. // ... 3. Workbook workbook = new Workbook(); 4. // Access a collection of columns. 5. ColumnCollection columns = workbook.Worksheets[0].Columns; 6. // Access the first column by its index in the collection of columns. 7. Column firstColumn_byIndex = columns[0]; 8. // Access the first column by its unique name. 9. Column firstColumn_byName = columns["A"];
3) Cell或者Cell區(qū)域的插入與刪除
插入:
1. using DevExpress.Spreadsheet; 2. // ... 3. Workbook workbook = new Workbook(); 4. Worksheet worksheet = workbook.Worksheets[0]; 5. // Insert a cell into the C5 position, shifting other cells in the same row to the right. 6. worksheet.InsertCells(worksheet.Cells["C5"], InsertCellsMode.ShiftCellsDown); 7. // Insert cells into the location of the H11:I12 range, shifting other cells in the same column down. 8. worksheet.InsertCells(worksheet.Range["H11:I12"], InsertCellsMode.ShiftCellsRight);
刪除:
1. using DevExpress.Spreadsheet; 2. // ... 3. Workbook workbook = new Workbook(); 4. Worksheet worksheet = workbook.Worksheets[0]; 5. // Delete the C5 cell, shifting other cells in the same row to the left. 6. worksheet.DeleteCells(worksheet.Cells["C5"], DeleteMode.ShiftCellsLeft); 7. // Delete the H11:I12 range of cells, shifting other cells in the same column up. 8. worksheet.DeleteCells(worksheet.Range["H11:I12"], DeleteMode.ShiftCellsUp);
4) Table Styles的創(chuàng)建、修改與刪除
1. using DevExpress.Spreadsheet;
2. // ...
3. // Access the table style to be modified.
4. TableStyle tableStyle = workbook.TableStyles["tableStyleName"];
5. // Change the required formatting characteristics of the style elements.
6. tableStyle.BeginUpdate();
7. try {
8. TableStyleElement wholeTable = tableStyle.TableStyleElements[TableStyleElementType.WholeTable];
9. // wholeTable.Fill...
10. // wholeTable.Borders...
11. // wholeTable.Font...
12. TableStyleElement tableHeader = tableStyle.TableStyleElements[TableStyleElementType.HeaderRow];
13. // tableHeader.Fill.BackgroundColor...
14. // tableHeader.Font...
15. TableStyleElement firstColumn = tableStyle.TableStyleElements[TableStyleElementType.FirstColumn];
16. // firstColumn.Clear();
17. // ...
18. }
19. finally {
5) 單元格添加超鏈接、批注
超鏈接:
1. // Create a hyperlink to a web page. 2. Cell cell = worksheet.Cells["A1"]; 3. worksheet.Hyperlinks.Add(cell, "//www.devexpress.com/", true, "DevExpress"); 4. // Create a hyperlink to a cell range in a workbook. 5. Range range = worksheet.Range["C3:D4"]; 6. Hyperlink cellHyperlink = worksheet.Hyperlinks.Add(range, "Sheet2!B2:E7", false, "Select Range"); 7. cellHyperlink.TooltipText = "Click Me";
批注:
1. using DevExpress.Spreadsheet;
2. //...
3. Workbook workbook = new Workbook();
4. Worksheet worksheet = workbook.Worksheets[0];
5. //Get the system username.
6. string author = workbook.CurrentAuthor;
7. //Add a comment to the A1 cell.
8. Cell cell = worksheet.Cells["A1"];
9. Comment comment = worksheet.Comments.Add(cell, author, "This is important information for users.");
10. //Add the author name at the beginning of the comment.
11. CommentRunCollection runs = comment.Runs;
12. runs.Insert(0, author + ": \r\n");
13. runs[0].Font.Bold = true;
14. //Format the comment text.
15. runs[1].Font.Color = Color.Red;
16. runs[1].Font.Name = "Times New Roman";
17. runs[1].Font.Size = 14;
18. runs[1].Font.Italic = true;
19. //Add a new comment run.
20. runs.Add("\n Never delete this comment!");
21. runs[2].Font.Color = Color.MidnightBlue;

本站文章除注明轉(zhuǎn)載外,均為本站原創(chuàng)或翻譯。歡迎任何形式的轉(zhuǎn)載,但請務(wù)必注明出處、不得修改原文相關(guān)鏈接,如果存在內(nèi)容上的異議請郵件反饋至chenjj@ke049m.cn