# How to import data from excel file with multiple sheets into stata

preview_player
Показать описание
How to import data from excel file with multiple sheets into stata

import excel "file location", sheet("Sheet1") firstrow
import excel "file location", sheet("Sheet2") firstrow
import excel "file location", sheet("Sheet3") firstrow
Рекомендации по теме
Комментарии
Автор

this is useless. how do you merge them into one dataset is the question.

sherifabdelhameed
Автор

this doesn't work when you have 40 sheets to merge

anikachhillar