title: Read Excel Cell Format
body: <p>I'm working on this program that will read the data in excel file and put it into our database. The program is written in Visual Studio 2010 using C#, and I'm using the NPOI library.</p>
  
  <p>In the past, I was able to read the spreadsheet row by row and cell by cell to get the data, but the new format of the excel file will not allow me to do this easily. (The excel is given by another user, so I can't really make big changes to it).</p>
  
  <p>There are several "tables" in one sheet (using borders and headers for each column name), and I will need to get data mainly from the tables but sometimes outside the tables too.</p>
  
  <p>I was wondering if I were to read the spreadsheet row by row (which is what I'm a bit for familiar with), is there a way I can tell that I have reached a table? Is there a way I can read the "format" of the cell?</p>
  
  <p>What I mean is, for example, "<em>this cell has borders around it so starting this row is a table.</em>" or "<em>the text in this cell is bold, so this row is the header row for this new table.</em>"</p>
  
  <p>In the past I was only able to read the "text" for the spreadsheet and not the format/style. I've been searching on the internet and I can only find how to set the style for output excel but not how to read the format from input.</p>
  
  <p>Any help is appreciated, thanks! </p>