I was able to create a base view over the excel datasource and read the data from all the sheets without the sheet name in the output by unchecking the “Extract sheet name as a new column” option. During my testing, I have enabled “Extract data from all sheets”, “Has Headers” and “Stream Tuples” option.
For your case, I would suggest you to drop the base view that was created when the “Extract sheet name as a new column” option is selected and recreate the base view after saving the data source changes(i.e unselect the “Extract sheet name as a new column” option). Reading the [Excel Sources](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/excel_sources/excel_sources) of the Virtual DataPort Administration Guide helped me understand the usage of Excel data sources.
For your second question, if the “Stream Tuples” option is **cleared**, the Server obtains the type of the field from the **file’s metadata**. But if the “Stream Tuples” option is **selected**, then the Server infers the type of each column from the **first row of the file**. For more information, refer to the [Stream Tuples](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/excel_sources/excel_sources#:~:text=Stream%20tuples:) Section of the Excel Sources documentation.
The scenario when the base view is returned the type as double, then I would create a derived view over the base view and convert this double field to int field using the **CAST** function. For e.g.
`CAST(‘int’,<double field name>)`
For more information, refer to the [CAST](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/type_conversion_functions#cast) Section of the Type Conversion Functions.
If you still need help and if you are a user with valid support access then you can raise a support case in [Denodo Support Site](https://support.denodo.com/) so that our support team can help you.
Hope this helps!