topic Loading multiple excel file with multiple sheet without using ODBC in QlikView https://community.qlik.com/t5/QlikView/Loading-multiple-excel-file-with-multiple-sheet-without-using/m-p/1202101#M880774 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have different excel file. Each file has multiple sheet. I want to load all the data in excel file in single load without using ODBC connection. I have Attached the sample file below. I need all the Data as like below</P><P>The Required Output:</P><P>Example:</P><P>StudentID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Name</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Raju</P><P>2</P><P>3</P><P>4</P><P>5</P><P>6</P><P>7</P><P>8</P><P>9</P><P>10</P><P>11</P><P>12</P><P>13</P><P>14</P><P>15</P><P>16</P><P>17</P><P>18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Magesh&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>In single table..Thanks in Advance..</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT hemachandran 2020-11-25T16:16:04Z Loading multiple excel file with multiple sheet without using ODBC https://community.qlik.com/t5/QlikView/Loading-multiple-excel-file-with-multiple-sheet-without-using/m-p/1202101#M880774 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have different excel file. Each file has multiple sheet. I want to load all the data in excel file in single load without using ODBC connection. I have Attached the sample file below. I need all the Data as like below</P><P>The Required Output:</P><P>Example:</P><P>StudentID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Name</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Raju</P><P>2</P><P>3</P><P>4</P><P>5</P><P>6</P><P>7</P><P>8</P><P>9</P><P>10</P><P>11</P><P>12</P><P>13</P><P>14</P><P>15</P><P>16</P><P>17</P><P>18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Magesh&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>In single table..Thanks in Advance..</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Loading-multiple-excel-file-with-multiple-sheet-without-using/m-p/1202101#M880774 hemachandran 2020-11-25T16:16:04Z