Styjun

Keep milk (or milk alternative) for a day without a fridge

Is `curl something | sudo bash -` a reasonably safe installation method?

As the Dungeon Master, how do I handle a player that insists on a specific class when I already know that choice will cause issues?

What would the EU do if an EU member declared war on another EU member?

Where is the USB2 OTG port on the RPi 4 Model B located?

Can I use "candidate" as a verb?

What's the point of this scene involving Flash Thompson at the airport?

Repeating redundant information after dialogues, to avoid or not?

Replacements for swear words

QGIS Welcome page: What is 'pin to list' for?

Is killing off one of my queer characters homophobic?

How did the Game Boy Advance stretch Game Boy games to widescreen?

How do Windows version numbers work?

Dropping outliers based on "2.5 times the RMSE"

Are there any double stars that I can actually see orbit each other?

<schwitz>, <zwinker> etc. Does German always use 2nd Person Singular Imperative verbs for emoticons? If so, why?

Is it rude to tell recruiters I would only change jobs for a better salary?

Am I testing diodes properly?

Filtering fine silt/mud from water (not necessarily bacteria etc.)

How did the hit man miss?

Grammy Winners Grading

Using ”as” after dialogue tags

Is an acid a salt or not?

How can an advanced civilization forget how to manufacture its technology?

Uncontrolled exception - System.Runtime.InteropServices.COMException: Uncontrolled Exception: HRESULT: 0X800A03EC

Catch multiple exceptions at once?Exception from HRESULT: 0x800A03ECError while saving the workbook : System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A03ECcom exception HRESULT: 0x800A03ECException from HRESULT: 0x800A03EC ErrorUnhandled Exception: System.Runtime.InteropServices.COMException (0x800A03EC)System.Runtime.InteropServices.COMException HRESULT : 0x800A03EC ObjectCharts PasteExcel : Exception of HRESULT : 0x800A03ECC# System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC Microsoft.Office.Interop.Excel._Workbook.SaveAs()“Exception from HRESULT: 0x800A03EC”

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I'm trying to export a datagridview that contains bitmap images, but it marks me an uncontrolled exception.
"System.Runtime.InteropServices.COMException: HRESULT: 0x800A03EC"

I have this code:

void exportexcel(DataGridView dgwObservaciones)
 
 Excel.Application oXL; //Se va usar Excel e interactuar con la aplicación
 Excel._Workbook oWB; //Crea el libro
 Excel._Worksheet oSheet;

 try
 
 //Inicia Excel
 oXL = new Excel.Application();
 oXL.Visible = true;
 //Obtiene el libro y la hoja con la que se va a trabajar
 oWB = (Excel._Workbook)(oXL.Workbooks.Add(Missing.Value));
 oSheet = (Excel._Worksheet)oWB.ActiveSheet;

 //Ancho de columnas
 oSheet.get_Range("A1").ColumnWidth = 30;
 oSheet.get_Range("B1", "D1").ColumnWidth = 50;
 //Empieza llenado
 oSheet = (Microsoft.Office.Interop.Excel.Worksheet)oWB.Worksheets.get_Item(1);

 //Recorremos el DataGridView rellenando la hoja de trabajo
 for (int i = 0; i < dgwObservaciones.Rows.Count; i++)
 
 for (int j = 0; j < dgwObservaciones.Columns.Count; j++)
 
 DataGridViewCell cell = dgwObservaciones[j, i];
 if (cell.Value.GetType() == typeof(Bitmap))
 
 // You have to get original bitmap path here
 string imagString = "bitmap1.bmp";
 Excel.Range oRange = (Excel.Range)oSheet.Cells[i + 1, j + 1];
 float Left = (float)((double)oRange.Left);
 float Top = (float)((double)oRange.Top);
 const float ImageSize = 32;
 oSheet.Shapes.AddPicture(imagString, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, Left, Top, ImageSize, ImageSize);
 oRange.RowHeight = ImageSize + 2;
 
 else
 
 oSheet.Cells[i + 1, j + 1] = cell.Value; //the error is in this line
 
 
 
 
 catch (Exception theException)
 
 String errorMessage;
 errorMessage = "Error: ";
 errorMessage = String.Concat(errorMessage, theException.Message);
 errorMessage = String.Concat(errorMessage, " Line: ");
 errorMessage = String.Concat(errorMessage, theException.Source);
 MessageBox.Show(errorMessage, "Error");
 

enter image description here
Help me please!!

c# image visual-studio export-to-excel

share|improve this question

asked Mar 26 at 4:25

Kanade Hix Sevilla SalazarKanade Hix Sevilla Salazar

111 bronze badge

add a comment | 

0

I'm trying to export a datagridview that contains bitmap images, but it marks me an uncontrolled exception.
"System.Runtime.InteropServices.COMException: HRESULT: 0x800A03EC"

I have this code:

void exportexcel(DataGridView dgwObservaciones)
 
 Excel.Application oXL; //Se va usar Excel e interactuar con la aplicación
 Excel._Workbook oWB; //Crea el libro
 Excel._Worksheet oSheet;

 try
 
 //Inicia Excel
 oXL = new Excel.Application();
 oXL.Visible = true;
 //Obtiene el libro y la hoja con la que se va a trabajar
 oWB = (Excel._Workbook)(oXL.Workbooks.Add(Missing.Value));
 oSheet = (Excel._Worksheet)oWB.ActiveSheet;

 //Ancho de columnas
 oSheet.get_Range("A1").ColumnWidth = 30;
 oSheet.get_Range("B1", "D1").ColumnWidth = 50;
 //Empieza llenado
 oSheet = (Microsoft.Office.Interop.Excel.Worksheet)oWB.Worksheets.get_Item(1);

 //Recorremos el DataGridView rellenando la hoja de trabajo
 for (int i = 0; i < dgwObservaciones.Rows.Count; i++)
 
 for (int j = 0; j < dgwObservaciones.Columns.Count; j++)
 
 DataGridViewCell cell = dgwObservaciones[j, i];
 if (cell.Value.GetType() == typeof(Bitmap))
 
 // You have to get original bitmap path here
 string imagString = "bitmap1.bmp";
 Excel.Range oRange = (Excel.Range)oSheet.Cells[i + 1, j + 1];
 float Left = (float)((double)oRange.Left);
 float Top = (float)((double)oRange.Top);
 const float ImageSize = 32;
 oSheet.Shapes.AddPicture(imagString, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, Left, Top, ImageSize, ImageSize);
 oRange.RowHeight = ImageSize + 2;
 
 else
 
 oSheet.Cells[i + 1, j + 1] = cell.Value; //the error is in this line
 
 
 
 
 catch (Exception theException)
 
 String errorMessage;
 errorMessage = "Error: ";
 errorMessage = String.Concat(errorMessage, theException.Message);
 errorMessage = String.Concat(errorMessage, " Line: ");
 errorMessage = String.Concat(errorMessage, theException.Source);
 MessageBox.Show(errorMessage, "Error");
 

enter image description here
Help me please!!

c# image visual-studio export-to-excel

share|improve this question

asked Mar 26 at 4:25

Kanade Hix Sevilla SalazarKanade Hix Sevilla Salazar

111 bronze badge

add a comment | 

I'm trying to export a datagridview that contains bitmap images, but it marks me an uncontrolled exception.
"System.Runtime.InteropServices.COMException: HRESULT: 0x800A03EC"

I have this code:

void exportexcel(DataGridView dgwObservaciones)
 
 Excel.Application oXL; //Se va usar Excel e interactuar con la aplicación
 Excel._Workbook oWB; //Crea el libro
 Excel._Worksheet oSheet;

 try
 
 //Inicia Excel
 oXL = new Excel.Application();
 oXL.Visible = true;
 //Obtiene el libro y la hoja con la que se va a trabajar
 oWB = (Excel._Workbook)(oXL.Workbooks.Add(Missing.Value));
 oSheet = (Excel._Worksheet)oWB.ActiveSheet;

 //Ancho de columnas
 oSheet.get_Range("A1").ColumnWidth = 30;
 oSheet.get_Range("B1", "D1").ColumnWidth = 50;
 //Empieza llenado
 oSheet = (Microsoft.Office.Interop.Excel.Worksheet)oWB.Worksheets.get_Item(1);

 //Recorremos el DataGridView rellenando la hoja de trabajo
 for (int i = 0; i < dgwObservaciones.Rows.Count; i++)
 
 for (int j = 0; j < dgwObservaciones.Columns.Count; j++)
 
 DataGridViewCell cell = dgwObservaciones[j, i];
 if (cell.Value.GetType() == typeof(Bitmap))
 
 // You have to get original bitmap path here
 string imagString = "bitmap1.bmp";
 Excel.Range oRange = (Excel.Range)oSheet.Cells[i + 1, j + 1];
 float Left = (float)((double)oRange.Left);
 float Top = (float)((double)oRange.Top);
 const float ImageSize = 32;
 oSheet.Shapes.AddPicture(imagString, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, Left, Top, ImageSize, ImageSize);
 oRange.RowHeight = ImageSize + 2;
 
 else
 
 oSheet.Cells[i + 1, j + 1] = cell.Value; //the error is in this line
 
 
 
 
 catch (Exception theException)
 
 String errorMessage;
 errorMessage = "Error: ";
 errorMessage = String.Concat(errorMessage, theException.Message);
 errorMessage = String.Concat(errorMessage, " Line: ");
 errorMessage = String.Concat(errorMessage, theException.Source);
 MessageBox.Show(errorMessage, "Error");
 

enter image description here
Help me please!!

c# image visual-studio export-to-excel

share|improve this question

asked Mar 26 at 4:25

Kanade Hix Sevilla SalazarKanade Hix Sevilla Salazar

111 bronze badge

void exportexcel(DataGridView dgwObservaciones)
 
 Excel.Application oXL; //Se va usar Excel e interactuar con la aplicación
 Excel._Workbook oWB; //Crea el libro
 Excel._Worksheet oSheet;

 try
 
 //Inicia Excel
 oXL = new Excel.Application();
 oXL.Visible = true;
 //Obtiene el libro y la hoja con la que se va a trabajar
 oWB = (Excel._Workbook)(oXL.Workbooks.Add(Missing.Value));
 oSheet = (Excel._Worksheet)oWB.ActiveSheet;

 //Ancho de columnas
 oSheet.get_Range("A1").ColumnWidth = 30;
 oSheet.get_Range("B1", "D1").ColumnWidth = 50;
 //Empieza llenado
 oSheet = (Microsoft.Office.Interop.Excel.Worksheet)oWB.Worksheets.get_Item(1);

 //Recorremos el DataGridView rellenando la hoja de trabajo
 for (int i = 0; i < dgwObservaciones.Rows.Count; i++)
 
 for (int j = 0; j < dgwObservaciones.Columns.Count; j++)
 
 DataGridViewCell cell = dgwObservaciones[j, i];
 if (cell.Value.GetType() == typeof(Bitmap))
 
 // You have to get original bitmap path here
 string imagString = "bitmap1.bmp";
 Excel.Range oRange = (Excel.Range)oSheet.Cells[i + 1, j + 1];
 float Left = (float)((double)oRange.Left);
 float Top = (float)((double)oRange.Top);
 const float ImageSize = 32;
 oSheet.Shapes.AddPicture(imagString, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, Left, Top, ImageSize, ImageSize);
 oRange.RowHeight = ImageSize + 2;
 
 else
 
 oSheet.Cells[i + 1, j + 1] = cell.Value; //the error is in this line
 
 
 
 
 catch (Exception theException)
 
 String errorMessage;
 errorMessage = "Error: ";
 errorMessage = String.Concat(errorMessage, theException.Message);
 errorMessage = String.Concat(errorMessage, " Line: ");
 errorMessage = String.Concat(errorMessage, theException.Source);
 MessageBox.Show(errorMessage, "Error");
 

share|improve this question

asked Mar 26 at 4:25

Kanade Hix Sevilla SalazarKanade Hix Sevilla Salazar

111 bronze badge

share|improve this question

asked Mar 26 at 4:25

Kanade Hix Sevilla SalazarKanade Hix Sevilla Salazar

111 bronze badge

asked Mar 26 at 4:25

Kanade Hix Sevilla SalazarKanade Hix Sevilla Salazar

111 bronze badge

asked Mar 26 at 4:25

Kanade Hix Sevilla SalazarKanade Hix Sevilla Salazar

111 bronze badge