How can I export all my issues from an Enterprise GitHub repository to an Excel file? I have tried searching many Stack Overflow answers but did not succeed. I tried this solution too (exporting Git issues to CSV and getting "ImportError: No module named requests" errors. Is there any tool or any easy way to export all the issues to Excel?
如何将所有问题从企业GitHub存储库导出到Excel文件?我尝试搜索了很多栈溢出的答案，但是没有成功。我也尝试了这个解决方案(将Git问题导出到CSV并获得“ImportError: No模块命名请求”错误。有没有什么工具或简单的方法可以导出所有的问题以Excel?
2 个解决方案
#1
17
To export from a private repo using curl, you can run the following:
要使用curl从私有repo导出，可以运行以下操作:
curl -i "https://api.github.com/repos/<repo-owner>/<repo-name>/issues" -u "<user-name>"
curl -i "https://api.github.com/repos/< repo_owner >/
Where the user has access to the private repo. You can then convert the resulting json into csv using any suitable converter as suggested in other answers.
用户可以访问私有的repo。然后，您可以像其他答案中建议的那样，使用任何合适的转换器将得到的json转换为csv。
Find authentication reference here.
在这里找到验证参考。
#2
6
If that is a one-time task, you may play around with GitHub WebAPI. It allows to export the issues in JSON format. Then you can convert it to Excel (e.g. using some online converter).
如果这是一次性任务，您可以使用GitHub WebAPI。它允许以JSON格式导出问题。然后你可以把它转换成Excel(例如使用在线转换器)。
Just open the following URL in a browser substituting the {owner} and {repo} with real values:
只需在浏览器中打开以下URL，将{owner}和{repo}替换为实值:
https://api.github.com/repos/{owner}/{repo}/issues?page=1&per_page=100
https://api.github.com/repos/ {所有者} / {回购} /问题? = 1 &per_page = 100页
#1
17
To export from a private repo using curl, you can run the following:
要使用curl从私有repo导出，可以运行以下操作:
curl -i "https://api.github.com/repos/<repo-owner>/<repo-name>/issues" -u "<user-name>"
curl -i "https://api.github.com/repos/< repo_owner >/
Where the user has access to the private repo. You can then convert the resulting json into csv using any suitable converter as suggested in other answers.
用户可以访问私有的repo。然后，您可以像其他答案中建议的那样，使用任何合适的转换器将得到的json转换为csv。
Find authentication reference here.
在这里找到验证参考。
#2
6
If that is a one-time task, you may play around with GitHub WebAPI. It allows to export the issues in JSON format. Then you can convert it to Excel (e.g. using some online converter).
如果这是一次性任务，您可以使用GitHub WebAPI。它允许以JSON格式导出问题。然后你可以把它转换成Excel(例如使用在线转换器)。
Just open the following URL in a browser substituting the {owner} and {repo} with real values:
只需在浏览器中打开以下URL，将{owner}和{repo}替换为实值:
https://api.github.com/repos/{owner}/{repo}/issues?page=1&per_page=100
https://api.github.com/repos/ {所有者} / {回购} /问题? = 1 &per_page = 100页