Question: how to read data from excel sheet using macro?
Answer: Click "Developer" in Excel's menu bar.
Click the Visual Basic icon in the ribbon's Code tab to launch the Visual Basic for Applications window.
Select the macro in the window's Project box that you want to read Excel's data.
Type the following line of code: ... 
Replace "Integer" with "String" if the cell contains a string.