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 = 0; i < workbookExcel.Worksheets.Count; i++)
                        {
string pngPath = pngDirectoryName + "\\" + (i + 1).ToString() + ".png";
                            Worksheet sheet = workbookExcel.Worksheets[i];
                            sheet.SaveToImage(pngPath);
                            sheet.Clear();
                            Thread.Sleep(100);
                            CaptureImage(pngPath, 0, 50, 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, 0, 0, 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 = 0;
if (saveFileDialog.ShowDialog() != DialogResult.OK)
return;
// 转换后的目标文件路径  
string destFilePath = saveFileDialog.FileName;
// 转换  
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(sourceFilePath);
            workbook.SaveToFile(destFilePath, fileFormat);