Click here to Skip to main content
15,887,485 members

Comments by Appokea (Top 4 by date)

Appokea 19-Feb-16 8:55am View    
You can refer to this article that demonstrates how to open an existing excel file in PHP.
Appokea 19-Feb-16 8:52am View    
Here is an article about reading, updating and writing excel files in PHP. I hope it helps.
Appokea 19-Feb-16 4:43am View    
Maria in case you're interested there is a direct way how you can export an excel file into a DataGridView with C#. Note that this approach keeps all the formatting from your excel file.
Appokea 19-Feb-16 4:38am View    
As mentioned below this task will require some alternative approach from OLEDB.
What I did in the past is I used a VB.NET library for excel processing, I would iterate through all the images in my spreadsheet file like the following:

Dim workbook = ExcelFile.Load("Sample.xlsx")

For Each worksheet In workbook.Worksheets
For Each picture In worksheet.Pictures
Dim picPosition As ExcelDrawingPosition = picture.Position
Dim picStream As MemoryStream = picture.PictureStream
' ...
Next
Next

Also I should point out that you can actually directly export your excel file into a DataGridView control with VB.NET code. Beside excel cells data this will also export hyperlinks, formattings, images, etc.