Import Excel File Information

[AmyshaDixon]

Using the following resources:

• csharp.net for a general tutorial
• Microsoft docs for interop set-up
• Microsoft docs for interop class definitions
• Microsoft docs for a interop assemblies

[AmyshaDixon]

• coderwall.com for another tutorial

[AmyshaDixon]

• excelhowto.com for more information on workseets vs. sheets

[AmyshaDixon]

• Microsoft docs for Worksheets.Range
• Microsoft docs for Worksheet.UsedRange

[AmyshaDixon]

• stackoverflow.com for selecting only an occupied range

[AmyshaDixon]

• Microsoft docs for Range.Value2

[AmyshaDixon]

• stackoverflow.com for deleting rows

[AmyshaDixon]

• stackoverflow.com for deleting rows with shiftDirection

• Microsoft docs for more information on Range.Delete

[AmyshaDixon]

• Microsoft docs for workbooks.open

[AmyshaDixon]

• stackoverflow.com for efficiency

[AmyshaDixon]

• Microsoft docs for OpenXML setup

[AmyshaDixon]

• Microsoft docs for OpenXML how-tos

• Microsoft docs for OpenXML classes

• Microsoft docs for opening/parsing

[AmyshaDixon]

• Microsoft docs to get values from cells

• stackoverflow to get values from cells without the extra fluff

[AmyshaDixon]

• stackoverflow for different methods of accessing OpenXML row count

[AmyshaDixon]

• stackoverflow for removing OpenXML rows

[AmyshaDixon]

• social.msdn.microsoft.com and stack overflow for OpenXML cell counts per row

[AmyshaDixon]

• Microsoft docs for the OpenXML row class