View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jeff Webb Jeff Webb is offline
external usenet poster
 
Posts: 6
Default Iterating through workbook capturing text

Why don't you just use interop to save the file as an XML Spreadsheet, then use an XSLT transform

Otherwise, you probably want to replace sheet.Cells with sheet.UsedRange, and I think cell.Text should be cell.Value in your second attempt

-- Jeff