Microsoft excel file xlsx as a data source
Download
1 / 2

Microsoft Excel File (XLSX) as a Data source - PowerPoint PPT Presentation


  • 68 Views
  • Uploaded on

Microsoft Excel File (XLSX) as a Data source. Excel file formats supported: XLS, XLSX, XLSM. Each worksheet in an excel file becomes a table The first row of each table MUST be the column names for the table CSV files are also supported Each file is the equivalent of a worksheet/table

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Microsoft Excel File (XLSX) as a Data source' - sadah


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Microsoft excel file xlsx as a data source

Microsoft Excel File (XLSX) as a Data source

  • Excel file formats supported: XLS, XLSX, XLSM.

  • Each worksheet in an excel file becomes a table

  • The first row of each table MUST be the column names for the table

  • CSV files are also supported

    • Each file is the equivalent of a worksheet/table

    • Adding one CSV as a data source, will automatically add all the .CSV files in the same directory, each one as its own table.


Microsoft excel file xlsx as a data source1
Microsoft Excel File (XLSX) as aData source

Simple table, created using a forEach. Joins tables Categories and Products on the key CategoryID, which is common to both tables.


ad