how to add image to my excel sheet by its original dimensions
Well, I think you may use first or second PictureCollection.Add() method (overloads) for your needs.
You may add a picture to the worksheet by calling the Add method of the Pictures collection (encapsulated in the Worksheet object). The Add method takes the following parameters to add a picture to the worksheet:
- Upper Left Row Index, represents the index of the upper left row.
- Upper Left Column Index, represents the index of the upper left column.
- Image File Name, represents the complete file name of the image to add to its file path.
Please check the document for your reference (especially the first example where the picture with original size would be inserted by default):