回复 3楼jason.zhou的帖子
jason.zhou 你好,
感谢你的分享。
我没能重现 3# 中的问题,能否发个 Demo 上了调试?
下面是我的测试代码:
- private void Form1_Load(object sender, EventArgs e)
- {
- int i;
- C1.C1Excel.XLSheet sheet = c1XLBook1.Sheets[0];
- for (i = 0; i <= 9; i++)
- {
- sheet[i, 0].Value = (i + 1) * 10;
- sheet[i, 1].Value = (i + 1) * 100;
- sheet[i, 2].Value = (i + 1) * 1000;
- }
-
- // Add style 1.
- XLStyle style1 = new XLStyle(c1XLBook1);
- style1.Font = new Font("Tahoma", 9, FontStyle.Bold);
- style1.ForeColor = Color.RoyalBlue;
-
- // Add style 2.
- XLStyle style2 = new XLStyle(c1XLBook1);
- style2.Font = new Font("Tahoma", 9, FontStyle.Italic);
- style2.BackColor = Color.RoyalBlue;
- style2.ForeColor = Color.White;
- for (i = 0; i <= 9; i++)
- {
- // Apply styles to the content.
- if ((i + 1) % 2 == 0)
- {
- sheet[i, 0].Style = style2;
- sheet[i, 1].Style = style1;
- sheet[i, 2].Style = style2;
- }
- else
- {
- sheet[i, 0].Style = style1;
- sheet[i, 1].Style = style2;
- sheet[i, 2].Style = style1;
- }
- }
- c1XLBook1.Sheets[0].Scale = 50;
- c1XLBook1.Save(@"mybook.xlsx");
- System.Diagnostics.Process.Start(@"mybook.xlsx");
- }
- }
复制代码 |