Title: Worksheet selection
Last modified: August 21, 2016

---

# Worksheet selection

 *  Resolved [paranoix](https://wordpress.org/support/users/paranoix/)
 * (@paranoix)
 * [11 years, 12 months ago](https://wordpress.org/support/topic/worksheet-selection/)
 * Hi Tobias,
 * Great job. TablePress is really helpful tool with lot of options.
    One option
   that I could not find is selecting a worksheet from XLS file. I made this by 
   changing 0 to 1 or 2 in class-import.php file of your code
 * $sheet = 0; // import first sheet of the Workbook
 * but maybe this option should be possible to set in import front desk?
    all the
   best,
 * Jan
 * [https://wordpress.org/plugins/tablepress/](https://wordpress.org/plugins/tablepress/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [11 years, 12 months ago](https://wordpress.org/support/topic/worksheet-selection/#post-5015462)
 * Hi,
 * thanks for your question, and sorry for the trouble.
 * You are correct, there is no option to select the worksheet yet, basically because
   the Excel import is still experimental.
    I’ll probably add an option in a future
   version, but in the meantime, I suggest to change the sheet number in the code(
   you already found the correct place), or to make the desired sheet the first 
   sheet in Excel, or to save the sheet as a CSV file and import that.
 * Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Worksheet selection’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [sheet](https://wordpress.org/support/topic-tag/sheet/)
 * [worksheet](https://wordpress.org/support/topic-tag/worksheet/)
 * [xls](https://wordpress.org/support/topic-tag/xls/)

 * 1 reply
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [11 years, 12 months ago](https://wordpress.org/support/topic/worksheet-selection/#post-5015462)
 * Status: resolved