将DataGridView数据导出到具有正确表格格式的Excel，HTML或Word中 [英] Export DataGridView Data with Images into Excel, HTML, or Word with Proper Table Formatting

问题描述

我有一个数据网格视图，其中加载了图像。作为此数据网格的源的表格具有图像路径，并使用该路径加载图像。我已经尝试导出数据到Excel并且成功，但似乎显示图像的一些问题。请任何帮助？任何帮助而不是Excel，HTML或Word或任何事情都会做，但请提供详细的帮助或导致很多问题。

这是我曾经用过的代码导出到Excel：

  saveFileDialog1.Filter =Excel（* .xls）| * .xls; 
 if（saveFileDialog1.ShowDialog（）== DialogResult.OK）
 {
 if（！saveFileDialog1.FileName.Equals（String.Empty））
 {
 FileInfo f = new FileInfo（saveFileDialog1.FileName）; 
 if（f.Extension.Equals（。xls））
 {
 Excel.Application xlApp; 
 Excel.Workbook xlWorkBook; 
 Excel.Worksheet xlWorkSheet; 
 object misValue = System.Reflection.Missing.Value; 
 
 xlApp = new Excel.ApplicationClass（）; 
 xlWorkBook = xlApp.Workbooks.Add（misValue）; 
 xlWorkSheet =（Excel.Worksheet）xlWorkBook.Worksheets.get_Item（1）; 
 int i = 0; 
 int j = 0; 
 
 for（i = 0; i< = dataGridView1.RowCount  -  1; i ++）
 {
 for（j = 0; j< = dataGridView1.ColumnCount  -  1 ; j ++）
 {
 
 DataGridViewCell cell = dataGridView1 [j，i]; 
 xlWorkSheet.Cells.Borders.LineStyle = Excel.XlLineStyle.xlContinuous; 
 xlWorkSheet.Columns.AutoFit（）; 
 if（cell.Value.GetType（）== typeof（Bitmap））
 {
 xlWorkSheet.Cells [i + 1，j + 1] = ReadFile（（Bitmap）cell.Value ）; 
} 
 else 
 {
 xlWorkSheet.Cells [i + 1，j + 1] = cell.Value; 
} 
 
} 
} 
 
 xlWorkBook.SaveAs（saveFileDialog1.FileName，Excel.XlFileFormat.xlWorkbookNormal，misValue，misValue，misValue，misValue，Excel .XlSaveAsAccessMode.xlExclusive，misValue，misValue，misValue，misValue，misValue）; 
 xlWorkBook.Close（true，misValue，misValue）; 
 xlApp.Quit（）; 
 
 releaseObject（xlWorkSheet）; 
 releaseObject（xlWorkBook）; 
 releaseObject（xlApp）; 
 
 MessageBox.Show（创建Excel文件，可以找到文件+ saveFileDialog1.FileName）; 
} 
 else 
 {
 MessageBox.Show（Invalid file type）; 
} 
} 
 else 
 {
 MessageBox.Show（你选择一个位置+ 
保存文件到）; 
} 
} 
  

表格格式为：

ax_no
rm_no
fullName
类型
照片//文件路径。
指纹//文件路径。

所有都是字符串。我也尝试过使用Spire.dataExport和iTextSharp，但它不起作用。

解决方案

如果您需要将图像放入单元格尝试这个代码：

  if（cell.Value.GetType（）== typeof（Bitmap） ）
 {
 //你必须在这里获得原始的位图路径
 string imagString =bitmap1.bmp; 
 Excel.Range oRange =（Excel.Range）xlWorkSheet.Cells [i + 1，j + 1]; 
 float Left =（float）（（double）oRange.Left）; 
 float Top =（float）（（double）oRange.Top）; 
 const float ImageSize = 32; 
 xlWorkSheet1.Shapes.AddPicture（imagString，Microsoft.Office.Core.MsoTriState.msoFalse，Microsoft.Office.Core.MsoTriState.msoCTrue，Left，Top，ImageSize，ImageSize）; 
 oRange.RowHeight = ImageSize + 2; 
} 
 else 
 {
 xlWorkSheet.Cells [i + 1，j + 1] = cell.Value; 
} 
  

I have a data grid view with images loaded into it. The table which is the source for this data grid has path for images and I load images using that path. I have tried to export data to Excel and was successful, but it seems to show some problems with images. Please any help? Any help instead of Excel, HTML, or Word or anything would do, but please provide detailed help or it causes a lot of problems.

Here is the code I used to export to Excel:

saveFileDialog1.Filter = "Excel (*.xls)|*.xls";
            if (saveFileDialog1.ShowDialog() == DialogResult.OK)
            {
                if (!saveFileDialog1.FileName.Equals(String.Empty))
                {
                    FileInfo f = new FileInfo(saveFileDialog1.FileName);
                    if (f.Extension.Equals(".xls"))
                    {
                        Excel.Application xlApp;
                        Excel.Workbook xlWorkBook;
                        Excel.Worksheet xlWorkSheet;
                        object misValue = System.Reflection.Missing.Value;

                        xlApp = new Excel.ApplicationClass();
                        xlWorkBook = xlApp.Workbooks.Add(misValue);
                        xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
                        int i = 0;
                        int j = 0;

                        for (i = 0; i <= dataGridView1.RowCount - 1; i++)
                        {
                            for (j = 0; j <= dataGridView1.ColumnCount - 1; j++)
                            {

                                DataGridViewCell cell = dataGridView1[j, i];
                                xlWorkSheet.Cells.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
                                xlWorkSheet.Columns.AutoFit();
                                if (cell.Value.GetType() == typeof(Bitmap))
                                {
                                    xlWorkSheet.Cells[i + 1, j + 1] = ReadFile((Bitmap)cell.Value);
                                }
                                else
                                {
                                    xlWorkSheet.Cells[i + 1, j + 1] = cell.Value;
                                }

                            }
                        }

                        xlWorkBook.SaveAs(saveFileDialog1.FileName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
                        xlWorkBook.Close(true, misValue, misValue);
                        xlApp.Quit();

                        releaseObject(xlWorkSheet);
                        releaseObject(xlWorkBook);
                        releaseObject(xlApp);

                        MessageBox.Show("Excel file created , you can find the file " + saveFileDialog1.FileName);
                    }
                    else
                    {
                        MessageBox.Show("Invalid file type");
                    }
                }
                else
                {
                    MessageBox.Show("You did pick a location " +
                                    "to save file to");
                }
            }

Table format is:

ax_no rm_no fullName Types photograph // path of file. Fingerprint // path of file.

All are strings. I have also tried using Spire.dataExport and iTextSharp but it doesn't work.

解决方案

If you need to place image into cell try this code:

if (cell.Value.GetType() == typeof(Bitmap))
{
    // You have to get original bitmap path here
    string imagString = "bitmap1.bmp";
    Excel.Range oRange = (Excel.Range)xlWorkSheet.Cells[i + 1, j + 1]; 
    float Left =(float) ((double)oRange.Left);
    float Top =(float) ((double)oRange.Top);
    const float ImageSize=32;
    xlWorkSheet1.Shapes.AddPicture(imagString, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, Left, Top, ImageSize, ImageSize);
    oRange.RowHeight = ImageSize + 2;
}
else
{
    xlWorkSheet.Cells[i + 1, j + 1] = cell.Value;
}

这篇关于将DataGridView数据导出到具有正确表格格式的Excel，HTML或Word中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！