Excel文件转为其他格式文件

引用：Spire.XLS 是一个 Excel 文件的读写库，无需安装office，使用起来也挺方便的。Spire还有一些其他的库（Spire.Doc，Spire.Pdf……）

说明：Spire.XLS.dll还会实例化Spire.Pdf.dll中的类，所以Spire.XLS.dll ，Spire.Pdf.dll ，Spire.License.dll 这3个dll一起使用

Excel转图片：

                    //初始化一个Workbook实例，并加载一个工作簿文件

                    Workbook workbookExcel = new Workbook();

                    workbookExcel.LoadFromFile(paramSourceBookPath);//路径

                    //循环将工作表保存为图片

                    if (workbookExcel != null)

                    {

                        for (int i = ; i < workbookExcel.Worksheets.Count; i++)

                        {

                            string pngPath = pngDirectoryName + "\\" + (i + ).ToString() + ".png";

                            Worksheet sheet = workbookExcel.Worksheets[i];

                            sheet.SaveToImage(pngPath);

                            sheet.Clear();

                            Thread.Sleep();

                            CaptureImage(pngPath, , , pngPath);//截取图片，去掉版本信息

                        }

                    }

试用版的spire.xls在转换时，会在文件中加入一个版本信息：Evaluation Warning : The document wascreated with Spire.XLS for .NET，去掉这个信息，我直接截取图片了

/// <summary>

        /// 截取图片(去掉版本信息：Evaluation Warning : The document wascreated with Spire.XLS for .NET)

        /// </summary>

        /// <param name="fromImagePath"></param>

        /// <param name="offsetX"></param>

        /// <param name="offsetY"></param>

        /// <param name="toImagePath"></param>

        public void CaptureImage(string fromImagePath, int offsetX, int offsetY, string toImagePath)

        {

            //原图片文件

            Image fromImage = Image.FromFile(fromImagePath);

            int width = fromImage.Width;

            int height = fromImage.Height - offsetY;

            //创建新图位图

            Bitmap bitmap = new Bitmap(width, height);

            //创建作图区域

            Graphics graphic = Graphics.FromImage(bitmap);

            //截取原图相应区域写入作图区

            graphic.DrawImage(fromImage, , , new Rectangle(offsetX, offsetY, width, height), GraphicsUnit.Pixel);

            //从作图区生成新图

            Image saveImage = Image.FromHbitmap(bitmap.GetHbitmap());

            //释放资源

            graphic.Dispose();

            bitmap.Dispose();

            fromImage.Dispose();

            FileInfo oldImage = new FileInfo(fromImagePath);

            if (oldImage.Exists)

            {

                global::System.IO.File.Delete(fromImagePath);

            }

            //保存图片

            saveImage.Save(toImagePath, System.Drawing.Imaging.ImageFormat.Png);

            //释放资源

            saveImage.Dispose();

        }

Excel转其他格式文件：

// 源文件路径

            string sourceFilePath = OpenFile.FileName;

            SaveFileDialog saveFileDialog = new SaveFileDialog();

            switch (fileFormat)

            {

                case FileFormat.Bitmap:

                    saveFileDialog.Filter = "Bitmap(*.bmp)|*.bmp";

                    break;

                case FileFormat.PDF:

                    saveFileDialog.Filter = "PDF Document(*.pdf)|*.pdf";

                    break;

                case FileFormat.ODS:

                    saveFileDialog.Filter = "OpenOffice Document Spreadsheet(*.ods)|*.ods";

                    break;

                case FileFormat.CSV:

                    saveFileDialog.Filter = "CSV(*.csv)|*.csv";

                    break;

                case FileFormat.XML:

                    saveFileDialog.Filter = "XML(*.xml)|*.xml";

                    break;

                case FileFormat.XPS:

                    saveFileDialog.Filter = "XPS(*.xps)|*.xps";

                    break;

                case FileFormat.Version2007:

                    saveFileDialog.Filter = "XPS(*.xps)|*.xps";

                    break;

                default:

                    break;

            }

            saveFileDialog.FilterIndex = ;

            if (saveFileDialog.ShowDialog() != DialogResult.OK)

                return;

            // 转换后的目标文件路径

            string destFilePath = saveFileDialog.FileName;

            // 转换

            Workbook workbook = new Workbook();

            workbook.LoadFromFile(sourceFilePath);

            workbook.SaveToFile(destFilePath, fileFormat);

巴特西

Excel文件转为其他格式文件

最新文章

热门文章