The latest articles on DEV Community by pulokjyotshna (@pulokjyotshna). https://dev.to/pulokjyotshna https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F455207%2Fa294550b-d05f-451e-8d74-b8597490dec7.png https://dev.to/pulokjyotshna en pulokjyotshna Wed, 19 Aug 2020 10:36:06 +0000 https://dev.to/pulokjyotshna/how-get-datas-from-multiple-sheets-of-an-excel-robot-framework-44d7 https://dev.to/pulokjyotshna/how-get-datas-from-multiple-sheets-of-an-excel-robot-framework-44d7 <div class="ltag__stackexchange--container"> <div class="ltag__stackexchange--title-container"> <div class="ltag__stackexchange--title"> <h1> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--pTF_nE4a--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackoverflow-logo-b42691ae545e4810b105ee957979a853a696085e67e43ee14c5699cf3e890fb4.svg" alt=""> <a href="https://stackoverflow.com/questions/63484908/how-to-get-data-of-multiple-sheets-from-an-excel-sheet-in-robot-framework" rel="noopener noreferrer"> How to get data of multiple sheets from an excel sheet in Robot framework </a> </h1> <div class="ltag__stackexchange--post-metadata"> <span>Aug 19 '20</span> <span>Comments: 1</span> <span>Answers: 0</span> </div> </div> <a class="ltag__stackexchange--score-container" href="https://stackoverflow.com/questions/63484908/how-to-get-data-of-multiple-sheets-from-an-excel-sheet-in-robot-framework" rel="noopener noreferrer"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--5MiFESHx--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackexchange-arrow-up-eff2e2849e67d156181d258e38802c0b57fa011f74164a7f97675ca3b6ab756b.svg" alt=""> <div class="ltag__stackexchange--score-number"> 0 </div> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--Rk_a5QFN--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackexchange-arrow-down-4349fac0dd932d284fab7e4dd9846f19a3710558efde0d2dfd05897f3eeb9aba.svg" alt=""> </a> </div> <div class="ltag__stackexchange--body"> <p>${file} Normalised Path _downloads {Filename} get file name important file xlsx true</p> <p>Open Excel Document ${file}/${filename} importantfile</p> <p>${Sheet1} Get Sheet review</p> <p>${Exceldata} create list</p> <p>For ${row} IN @{sheetvalues} Continue for loop if ${row}[0]=='date'</p> <p>Append to list ${exceldata} ${row}</p> <p>END</p> <p>This is giving value for only one sheet. How can I…</p> </div> <div class="ltag__stackexchange--btn--container"> <a href="https://stackoverflow.com/questions/63484908/how-to-get-data-of-multiple-sheets-from-an-excel-sheet-in-robot-framework" rel="noopener noreferrer">Open Full Question</a> </div> </div> pulokjyotshna Wed, 19 Aug 2020 10:34:11 +0000 https://dev.to/pulokjyotshna/how-to-read-datas-from-multiple-sheets-in-excel-sheet-43d1 https://dev.to/pulokjyotshna/how-to-read-datas-from-multiple-sheets-in-excel-sheet-43d1 <div class="ltag__stackexchange--container"> <div class="ltag__stackexchange--title-container"> <div class="ltag__stackexchange--title"> <h1> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--pTF_nE4a--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackoverflow-logo-b42691ae545e4810b105ee957979a853a696085e67e43ee14c5699cf3e890fb4.svg" alt=""> <a href="https://stackoverflow.com/questions/63484908/how-to-get-data-of-multiple-sheets-from-an-excel-sheet-in-robot-framework" rel="noopener noreferrer"> How to get data of multiple sheets from an excel sheet in Robot framework </a> </h1> <div class="ltag__stackexchange--post-metadata"> <span>Aug 19 '20</span> <span>Comments: 1</span> <span>Answers: 0</span> </div> </div> <a class="ltag__stackexchange--score-container" href="https://stackoverflow.com/questions/63484908/how-to-get-data-of-multiple-sheets-from-an-excel-sheet-in-robot-framework" rel="noopener noreferrer"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--5MiFESHx--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackexchange-arrow-up-eff2e2849e67d156181d258e38802c0b57fa011f74164a7f97675ca3b6ab756b.svg" alt=""> <div class="ltag__stackexchange--score-number"> 0 </div> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--Rk_a5QFN--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackexchange-arrow-down-4349fac0dd932d284fab7e4dd9846f19a3710558efde0d2dfd05897f3eeb9aba.svg" alt=""> </a> </div> <div class="ltag__stackexchange--body"> <p>${file} Normalised Path _downloads {Filename} get file name important file xlsx true</p> <p>Open Excel Document ${file}/${filename} importantfile</p> <p>${Sheet1} Get Sheet review</p> <p>${Exceldata} create list</p> <p>For ${row} IN @{sheetvalues} Continue for loop if ${row}[0]=='date'</p> <p>Append to list ${exceldata} ${row}</p> <p>END</p> <p>This is giving value for only one sheet. How can I…</p> </div> <div class="ltag__stackexchange--btn--container"> <a href="https://stackoverflow.com/questions/63484908/how-to-get-data-of-multiple-sheets-from-an-excel-sheet-in-robot-framework" rel="noopener noreferrer">Open Full Question</a> </div> </div> pulokjyotshna Wed, 19 Aug 2020 10:29:09 +0000 https://dev.to/pulokjyotshna/how-to-read-datas-from-multiple-tabs-in-excel-sheet-45eh https://dev.to/pulokjyotshna/how-to-read-datas-from-multiple-tabs-in-excel-sheet-45eh <div class="ltag__stackexchange--container"> <div class="ltag__stackexchange--title-container"> <div class="ltag__stackexchange--title"> <h1> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--pTF_nE4a--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackoverflow-logo-b42691ae545e4810b105ee957979a853a696085e67e43ee14c5699cf3e890fb4.svg" alt=""> <a href="https://stackoverflow.com/questions/63484908/how-to-get-data-of-multiple-sheets-from-an-excel-sheet-in-robot-framework" rel="noopener noreferrer"> How to get data of multiple sheets from an excel sheet in Robot framework </a> </h1> <div class="ltag__stackexchange--post-metadata"> <span>Aug 19 '20</span> <span>Comments: 1</span> <span>Answers: 0</span> </div> </div> <a class="ltag__stackexchange--score-container" href="https://stackoverflow.com/questions/63484908/how-to-get-data-of-multiple-sheets-from-an-excel-sheet-in-robot-framework" rel="noopener noreferrer"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--5MiFESHx--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackexchange-arrow-up-eff2e2849e67d156181d258e38802c0b57fa011f74164a7f97675ca3b6ab756b.svg" alt=""> <div class="ltag__stackexchange--score-number"> 0 </div> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--Rk_a5QFN--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackexchange-arrow-down-4349fac0dd932d284fab7e4dd9846f19a3710558efde0d2dfd05897f3eeb9aba.svg" alt=""> </a> </div> <div class="ltag__stackexchange--body"> <p>${file} Normalised Path _downloads {Filename} get file name important file xlsx true</p> <p>Open Excel Document ${file}/${filename} importantfile</p> <p>${Sheet1} Get Sheet review</p> <p>${Exceldata} create list</p> <p>For ${row} IN @{sheetvalues} Continue for loop if ${row}[0]=='date'</p> <p>Append to list ${exceldata} ${row}</p> <p>END</p> <p>This is giving value for only one sheet. How can I…</p> </div> <div class="ltag__stackexchange--btn--container"> <a href="https://stackoverflow.com/questions/63484908/how-to-get-data-of-multiple-sheets-from-an-excel-sheet-in-robot-framework" rel="noopener noreferrer">Open Full Question</a> </div> </div>