Get data style from Excel

复制代码
try
            {
                Excel.Application app = new Excel.Application();
                string excelFilePath = @"H:\22.xlsx";
                Excel.Workbook book = app.Workbooks.Open(excelFilePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
                StringBuilder sb = new StringBuilder();
                Excel.Worksheet sheet = book.Sheets[1] as Worksheet;
                for (int i = 0; i < 4; i++)
                {
                    for (int k = 0; k < 4; k++)
                    {
                        try
                        {
                            Excel.Range range = (Excel.Range)sheet.Cells[i, k];
                            string fontName = range.Font.Name as string;
                            string fontSize = ((int)range.Font.Size).ToString();

                            string bgColor = (range.Interior.Color as object).ToString();
                            string height = ((float)range.Height).ToString();
                            string width = ((float)range.Width).ToString();

                            
                            string valign = GetVerticalAlignmentName((int)range.VerticalAlignment);
                            string halign = GetHorizontalAlignmentName((int)range.HorizontalAlignment);

                            string text = (range.Text as object).ToString();

                            string interior = range.Interior.Color as string;
                            
                            sb.AppendLine("Row:" + i.ToString() + " Col:" + k.ToString() + " Font:" + fontName);
                            sb.AppendLine("Row:" + i.ToString() + " Col:" + k.ToString() + " fontSize:" + fontSize);

                            sb.AppendLine("Row:" + i.ToString() + " Col:" + k.ToString() + " bgColor:" + bgColor);
                            sb.AppendLine("Row:" + i.ToString() + " Col:" + k.ToString() + " height:" + height);
                            sb.AppendLine("Row:" + i.ToString() + " Col:" + k.ToString() + " width:" + width);
                            sb.AppendLine("Row:" + i.ToString() + " Col:" + k.ToString() + " text:" + text);

                            sb.AppendLine("Row:" + i.ToString() + " Col:" + k.ToString() + " valign:" + valign);

                            sb.AppendLine("Row:" + i.ToString() + " Col:" + k.ToString() + " interior:" + interior);


                        }
                        catch(Exception ex)
                        {
                            //sb.AppendLine(ex.ToString());
 
                        }
                    }
                }
                this.richTextBox1.Text = sb.ToString();

                book.Close(true, Type.Missing, Type.Missing);
                book = null;
                app.Quit();
                app = null;
                
            }
            catch
            {
 
            }
复制代码

 

posted on   笑东风  阅读(300)  评论(0编辑  收藏  举报

编辑推荐:
· AI与.NET技术实操系列:基于图像分类模型对图像进行分类
· go语言实现终端里的倒计时
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
阅读排行:
· 分享一个免费、快速、无限量使用的满血 DeepSeek R1 模型,支持深度思考和联网搜索!
· 基于 Docker 搭建 FRP 内网穿透开源项目(很简单哒)
· 25岁的心里话
· ollama系列01:轻松3步本地部署deepseek,普通电脑可用
· 按钮权限的设计及实现

导航

点击右上角即可分享
微信分享提示