Advertisement
Guest User

Untitled

a guest
Oct 1st, 2014
180
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. SLDocument sl = new SLDocument("example.xlsx", "Sheet1");
  2. int rowNum = Convert.ToInt32(barcodeNum.Text);
  3. string cellAddr = "C" + barcodeNum.Text;
  4. string cellEnvelope = "B" + barcodeNum.Text;
  5. string cellOutDate = "E" + barcodeNum.Text;
  6. int envelopeNumber = Convert.ToInt32(envelopeNum.Text);
  7. string address = sl.GetCellValueAsString(cellAddr);
  8. MessageBox.Show(address);
  9. sl.SetCellValue(cellEnvelope, envelopeNum.Text);
  10. sl.SetCellValue(cellOutDate, DateTime.Now);
  11. sl.SaveAs("Example.xls");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement