Search notes:

Reading the data of an Excel Range with Power Query

The following Power Query code reads the data from the range named dataRange, uses the ranges first row to assign column names (Table.PromoteHeaders), specifies the columns' data types (Table.TranformColumnTypes) and assigns the data to the variable tab:

let
   tab = Table.TransformColumnTypes(
           Table.PromoteHeaders(Excel.CurrentWorkbook(){[Name="dataRange"]}[Content]),
           {
             {"Col A" , type text  },
             {"Col B" , type number},
             {"Col C" , type number}
            }
          )
in
   tab

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/Microsof...', 1788558203, '216.73.216.30', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/Microsoft/Office/Excel/Object-Model/Range/power-query(47): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

Reading the data of an Excel Range with Power Query

See also