use the class I wrote above. then create another class which uses the ExcelReader class. In new class create a function. In this function create an ExcelReader and an ExcelWriter(I'll explain it below) object, and get its row count:
ExcelWriter ew = new ExcelWriter();
ExcelReader er = new ExcelReader(s); // the "s" parameter is the path of the file, can use the file name directly.
int rows = er.getRowCount();
now we need an ExcelWriter class.
namespace WindowsFormsApplication1
{
class ExcelWriter
{
private Microsoft.Office.Interop.Excel.Application app = null;
private Microsoft.Office.Interop.Excel.Workbook workbook = null;
private Microsoft.Office.Interop.Excel.Worksheet worksheet = null;
private Microsoft.Office.Interop.Excel.Range workSheet_range = null;
public ExcelWriter()
{
try
{
app = new Microsoft.Office.Interop.Excel.Application();
app.Visible = false;
workbook = app.Workbooks.Add(1);
worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Sheets[1];
workSheet_range = worksheet.get_Range("A1", "B1");
}
catch (Exception e)
{
Console.Write(e.ToString());
}
}
public void addData(int row, int col, string data)
{
worksheet.Cells[row, col] = data;
}
}
}
this can be used as ExcelWriter class, or you can add the constructor and addData function to the ExcelReader class.
now in the class you have created, you have rows variable. make a for loop with var rows:
for (int r = 1; r <= rows; r++)
{
string value = er.read(r, 1); //reads your excel file
//here you should create your if conditions. like if the "value==null"
// don't forget that your value type is always string. so you cannot make your conditions using the type variable. you should find another way to check it.
if (a == b){
ew.addData(r, 1, "=" + value);
//assume the value is "2*2.5", it makes a new Excel file with "=2*2.5" value.
}
}
Thats all I know.
Writing to excel using C#
