entityMap|blocks|key|3q7o3|text|要使用curl从私有存储库导出，可以运行以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|f4nql|curl+-i+https://api.github.com/repos///issues+--header+"Authorization:+token+"|code-block|syntax|javascript|ccd38|可以在下面生成令牌|2peb5|个人访问令牌|88sus|检查|43ms|接口说明|12jd2|获取所有详细信息。^0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|R|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|S|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|T|9|@]|A|@]|B|$]]|$2|J|4|K|6|7|8|U|9|@]|A|@]|B|$]]|$2|L|4|M|6|7|8|V|9|@]|A|@]|B|$]]|$2|N|4|O|6|7|8|W|9|@]|A|@]|B|$]]|$2|P|4|Q|6|7|8|X|9|@]|A|@]|B|$]]]]

To export from a private repo using curl, you can run the following:
<pre class="lang-sh prettyprint-override"><code>curl -i https://api.github.com/repos/&lt;repo-owner&gt;/&lt;repo-name&gt;/issues --header &quot;Authorization: token &lt;token&gt;&quot; 
</code></pre>
The token can be generated under <a href="https://github.com/settings/tokens" rel="noreferrer">Personal access tokens</a>
Inspect the <a href="https://docs.github.com/en/rest/reference/issues" rel="noreferrer">API description</a> for all details.

entityMap|blocks|key|3t0ao|text|The+The+The|type|unstyled|depth|inlineStyleRanges|entityRanges|data|b30o5|集线器|aftso|github的命令行包装器使这件事变得非常简单。|fp06g|你可以这样做：|1ijum|$+hub+issue+-f+"%25t,%25l%25n"+>+list.csv|code-block|syntax|javascript|cgqas|它会给你类似这样的东西|1j48p|$+more+issue.csv

Issue+1+title,+tag1+tag2
Issue+2+title,+tag3+tag2
Issue+3+title,+tag1^0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|R|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|S|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|T|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|U|9|@]|A|@]|B|$]]|$2|I|4|J|6|K|8|V|9|@]|A|@]|B|$L|M]]|$2|N|4|O|6|7|8|W|9|@]|A|@]|B|$]]|$2|P|4|Q|6|K|8|X|9|@]|A|@]|B|$L|M]]]]

The <a href="https://hub.github.com/" rel="noreferrer">hub</a> command-line wrapper for github makes this pretty simple. 

You can do something like this: 

<pre><code>$ hub issue -f "%t,%l%n" &gt; list.csv
</code></pre>

which gives you something like this

<pre><code>$ more issue.csv

Issue 1 title, tag1 tag2
Issue 2 title, tag3 tag2
Issue 3 title, tag1
</code></pre>

entityMap|blocks|key|d2i9b|text|和官员|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4st81|GitHub命令行界面|bvgh6|您可以轻松地将所有问题导出为CSV格式。|eb449|brew+install+gh|code-block|syntax|javascript|895q|登录：|enm52|gh+auth+login|88c2|将目录更改为存储库，然后运行以下命令：|bf4jk|gh+issue+list+--limit+1000+--state+all+%7C+tr+'\t'+','+>+issues.csv|fr08i|在欧洲的.csv文件中，分隔符是分号|74t7n|，而不是逗号。根据需要修改分隔符。^0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|X|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|Y|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|Z|9|@]|A|@]|B|$]]|$2|G|4|H|6|I|8|10|9|@]|A|@]|B|$J|K]]|$2|L|4|M|6|7|8|11|9|@]|A|@]|B|$]]|$2|N|4|O|6|I|8|12|9|@]|A|@]|B|$J|K]]|$2|P|4|Q|6|7|8|13|9|@]|A|@]|B|$]]|$2|R|4|S|6|I|8|14|9|@]|A|@]|B|$J|K]]|$2|T|4|U|6|7|8|15|9|@]|A|@]|B|$]]|$2|V|4|W|6|7|8|16|9|@]|A|@]|B|$]]]]

With the official <a href="https://cli.github.com" rel="noreferrer">GitHub CLI</a> you can easily export all issues into a CSV format.
<pre><code>brew install gh
</code></pre>
Log in:
<pre><code>gh auth login
</code></pre>
Change directory to a repository and run this command:
<pre><code>gh issue list --limit 1000 --state all | tr '\t' ',' &gt; issues.csv
</code></pre>
In the European .csv files the separator is a semicolon <code>';'</code>, not a comma. Modify the separator as you want.

entityMap|blocks|key|c21a1|text|如果这是一次性任务，您可以尝试|type|unstyled|depth|inlineStyleRanges|entityRanges|data|aciam|GitHub+WebAPI|160cv|..。它允许以JSON格式导出问题。然后，您可以将其转换为Excel+(例如，使用一些|7j143|在线转换器|c400v|)。|1nruf|只需在浏览器中打开以下URL，替换|4qe8c|和|6210m|使用实值：^0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|Q|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|R|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|S|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|T|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|U|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|V|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|W|9|@]|A|@]|B|$]]|$2|O|4|P|6|7|8|X|9|@]|A|@]|B|$]]]]

If that is a one-time task, you may play around with <a href="https://api.github.com/" rel="noreferrer">GitHub WebAPI</a>. It allows to export the issues in JSON format. Then you can convert it to Excel (e.g. using some <a href="https://konklone.io/json/" rel="noreferrer">online converter</a>).

Just open the following URL in a browser substituting the <code>{owner}</code> and <code>{repo}</code> with real values:

<code>https://api.github.com/repos/{owner}/{repo}/issues?page=1&amp;per_page=100</code>

entityMap|blocks|key|eh1b4|text|不幸的是，github.com并没有让这一切变得更容易。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|8mgjb|同时，如果您有jq和curl，您可以使用类似以下示例的两行代码来完成此操作，该示例输出问题编号、标题和标签(标签)，也适用于私有repos+(如果您不想按标签过滤，只需删除|ejsm6|url的一部分)。您需要替换$owner、$repo、$label和$username：|9s75v|#+with+personal+access+token+=+$PAT
echo+"number,+title,+labels"+>+issues.csv
curl+"https://api.github.com/repos/$owner/$repo/issues?labels=$label&page=1&per_page=100"+-u+"$username:$PAT"+\
%7C+jq+-r+'.[]+%7C+[.number,+.title,+(.labels%7Cmap(.name)%7Cjoin("/"))]%7C@csv'+>>+issues.csv

#+without+PAT+(will+be+prompted+for+password)
echo+"number,+title,+labels"+>+issues.csv
curl+"https://api.github.com/repos/$owner/$repo/issues?labels=$label&page=1&per_page=100"+-u+"$username"+\
%7C+jq+-r+'.[]+%7C+[.number,+.title,+(.labels%7Cmap(.name)%7Cjoin("/"))]%7C@csv'+>>+issues.csv|code-block|syntax|javascript|1990o|请注意，如果您的数据超过1页，则可能需要额外的调用。^0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|N|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|O|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|P|9|@]|A|@]|B|$]]|$2|G|4|H|6|I|8|Q|9|@]|A|@]|B|$J|K]]|$2|L|4|M|6|7|8|R|9|@]|A|@]|B|$]]]]

It is unfortunate that github.com does not make this easier. 

In the mean time, if you have jq and curl, you can do this in two lines using something like the following example that outputs issue number, title and labels (tags) and works for private repos as well (if you don't want to filter by label, just remove the <code>labels={label}&amp;</code> part of the url). You'll need to substitute $owner, $repo, $label, and $username:

<pre><code># with personal access token = $PAT
echo "number, title, labels" &gt; issues.csv
curl "https://api.github.com/repos/$owner/$repo/issues?labels=$label&amp;page=1&amp;per_page=100" -u "$username:$PAT" \
| jq -r '.[] | [.number, .title, (.labels|map(.name)|join("/"))]|@csv' &gt;&gt; issues.csv

# without PAT (will be prompted for password)
echo "number, title, labels" &gt; issues.csv
curl "https://api.github.com/repos/$owner/$repo/issues?labels=$label&amp;page=1&amp;per_page=100" -u "$username" \
| jq -r '.[] | [.number, .title, (.labels|map(.name)|join("/"))]|@csv' &gt;&gt; issues.csv
</code></pre>

Note that if your data exceeds 1 page, it may require additional calls.

entityMap|blocks|key|7l310|text|我尝试了关于以JSON格式导出问题的其他评论中描述的方法。它工作得很好，但格式不知何故搞砸了。然后，我在Excel帮助中发现，它能够直接访问API，并将JSON响应中的数据整齐地加载到我的Excel工作表中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|7ffc0|我用来寻找帮助的谷歌术语是"excel+power+query+web.content+GET+json“。我发现了一个如何使用Excel的视频，这对我很有帮助。|79qf2|在Excel查询中工作的URL+(与其他帖子中的相同)：|k7n2|https://api.github.com/repos/{owner}/{repo}/issues?page=1&per_page=100|code-block|syntax|javascript|3so98|就我个人而言，我还添加了参数&state=open，否则我需要请求数百个页面。有一次，我达到了GitHub对我的IP地址的未认证API调用/小时的限制。^0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|N|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|O|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|P|9|@]|A|@]|B|$]]|$2|G|4|H|6|I|8|Q|9|@]|A|@]|B|$J|K]]|$2|L|4|M|6|7|8|R|9|@]|A|@]|B|$]]]]

I tried the methods described in other comments regarding exporting issues in JSON format. It worked ok but the formatting was somehow screwed up. Then I found in Excel help that it is able to access APIs directly and load the data from the JSON response neatly into my Excel sheets.

The Google terms I used to find the help I needed were "excel power query web.content GET json". I found a How To Excel video which helped a lot.

URL that worked in the Excel query (same as from other posts): 

<pre><code>https://api.github.com/repos/{owner}/{repo}/issues?page=1&amp;per_page=100
</code></pre>

Personally, I also add the parameter &amp;state=open, otherwise I need to request hundreds of pages. At one point I reached GitHub's limit on unauthenticated API calls/hour for my IP address.

entityMap|blocks|key|bn7hs|text|您也可以尝试|type|unstyled|depth|inlineStyleRanges|entityRanges|data|diksp|https://github.com/remoteorigin/git-issues-downloader|cski|但是一定要使用开发分支。npm版本和master分支有buggy。|8d89v|或者，您可以将此修补版本与|4g3b6|npm+install+-g+https://github.com/mkobar/git-issues-downloader|code-block|syntax|javascript|523eh|然后运行(用于公共回购)|4b1s0|git-issues-downloader+-n+-p+none+-u+none+https://github.com//|8jauk|或者用于私有回购：|1ibbu|git-issues-downloader+-n+-p++-u++https://github.com//|fhk75|效果很好。^0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|X|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|Y|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|Z|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|10|9|@]|A|@]|B|$]]|$2|I|4|J|6|K|8|11|9|@]|A|@]|B|$L|M]]|$2|N|4|O|6|7|8|12|9|@]|A|@]|B|$]]|$2|P|4|Q|6|K|8|13|9|@]|A|@]|B|$L|M]]|$2|R|4|S|6|7|8|14|9|@]|A|@]|B|$]]|$2|T|4|U|6|K|8|15|9|@]|A|@]|B|$L|M]]|$2|V|4|W|6|7|8|16|9|@]|A|@]|B|$]]]]

You can also try <a href="https://github.com/remoteorigin/git-issues-downloader" rel="nofollow noreferrer">https://github.com/remoteorigin/git-issues-downloader</a> but be sure to used the develop branch. The npm version and master branch is buggy.

Or you can use this patched version with

<pre><code>npm install -g https://github.com/mkobar/git-issues-downloader
</code></pre>

and then run with (for public repo)

<pre><code>git-issues-downloader -n -p none -u none https://github.com/&lt;user&gt;/&lt;repository&gt;
</code></pre>

or for a private repo:

<pre><code>git-issues-downloader -n -p &lt;password or token&gt; -u &lt;user&gt; https://github.com/&lt;user&gt;/&lt;repository&gt;
</code></pre>

Works great.

entityMap|blocks|key|82cbf|text|这里有一个工具可以帮你做到这一点(使用GitHub应用编程接口)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|31igl|https://github.com/gavinr/github-csv-tools^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|F|9|@]|A|@]|B|$]]]]

Here is a tool that does it for you (uses the GitHub API):
<a href="https://github.com/gavinr/github-csv-tools" rel="nofollow noreferrer">https://github.com/gavinr/github-csv-tools</a>

entityMap|blocks|key|8k8dd|text|我已经修补了很长一段时间，发现Power+BI是使电子表格中的数据保持最新的一种很好的方法。我不得不研究一下Power+BI才能做到这一点，因为从结构化的JSON字段中获取正确的信息，并将列表折叠成连接字符串，尤其是标签，并不是非常直观。但这个Power+BI查询对我来说很有效，因为它消除了所有噪音，并将相关信息转换为易于理解的格式，可以与利益相关者一起审查：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|c2f20|let
++++MyJsonRecord+=+Json.Document(Web.Contents("https://api.github.com/repos///issues?&per_page=100&page=1&state=open&filter=all",+[Headers=[Authorization="Basic+",+Accept="application/vnd.github.symmetra-preview%2Bjson"]])),
++++MyJsonTable+=+Table.FromRecords(MyJsonRecord),
++++#"Column+selection"+=+Table.SelectColumns(MyJsonTable,{"number",+"title",+"user",+"labels",+"state",+"assignee",+"assignees",+"comments",+"created_at",+"updated_at",+"closed_at",+"body"}),
++++#"Expanded+labels"+=+Table.ExpandListColumn(#"Column+selection",+"labels"),
++++#"Expanded+labels1"+=+Table.ExpandRecordColumn(#"Expanded+labels",+"labels",+{"name"},+{"labels.name"}),
++++#"Grouped+Rows"+=+Table.Group(#"Expanded+labels1",+{"number","title",+"user",+"state",+"assignee",+"assignees",+"comments",+"created_at",+"updated_at",+"closed_at",+"body"},+{{"Label",+each+Text.Combine([labels.name],","),+type+text}}),
++++#"Removed+Other+Columns"+=+Table.SelectColumns(#"Grouped+Rows",{"number",+"title",+"state",+"assignee",+"comments",+"created_at",+"updated_at",+"closed_at",+"body",+"Label"}),
++++#"Expanded+assignee"+=+Table.ExpandRecordColumn(#"Removed+Other+Columns",+"assignee",+{"login"},+{"assignee.login"})
in
++++#"Expanded+assignee"|code-block|syntax|javascript|f52i9|我在本文中添加了列，然后又删除了列，并且没有对其进行清理-在使用它之前，请随意这样做。显然，您还必须在URL中填写您自己的组织名称和存储库名称，并获得auth令牌。我已经用Chrome+REST插件测试了URL，并通过输入用户和api密钥获得了令牌。如果您不想处理令牌，可以使用用户和密钥从Excel显式地进行身份验证。我只是发现在查询设置中使用匿名路由更简单，而是提供易于格式化的请求标头。|1npas|此外，这适用于具有多达100个开放问题的repos。如果您有更多内容，则需要复制查询(针对第2页等)并合并结果。|abmv|使用此查询的步骤：|fptj|在新工作表的"Data“选项卡上，打开"Get+Data”下拉列表|20hq1|选择“启动电源查询编辑器”|a6fkt|在编辑器中，依次选择"New+Query“、"Other+Sources”、"Blank+query“|b0t4q|现在你点击“高级编辑器”并粘贴上面的查询|60l2l|单击“高级编辑器”上的“完成”按钮，然后单击工具栏中的“关闭并加载”按钮。|cvi7o|问题正在加载到您的电子表格中，并且您已在业务中|97qn6|不需要糟糕的第三方工具^0|0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|11|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|12|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|13|9|@]|A|@]|B|$]]|$2|J|4|K|6|7|8|14|9|@]|A|@]|B|$]]|$2|L|4|M|6|7|8|15|9|@]|A|@]|B|$]]|$2|N|4|O|6|7|8|16|9|@]|A|@]|B|$]]|$2|P|4|Q|6|7|8|17|9|@]|A|@]|B|$]]|$2|R|4|S|6|7|8|18|9|@]|A|@]|B|$]]|$2|T|4|U|6|7|8|19|9|@]|A|@]|B|$]]|$2|V|4|W|6|7|8|1A|9|@]|A|@]|B|$]]|$2|X|4|Y|6|7|8|1B|9|@]|A|@]|B|$]]|$2|Z|4|10|6|7|8|1C|9|@]|A|@]|B|$]]]]

I have tinkered with this for quite some time and found that Power BI is a good way of keeping the data up to date in the spreadsheet. I had to look into Power BI a little to make this work, because getting the right info out of the structured JSON fields, and collapsing lists into concatenated strings, especially for labels, wasn't super intuitive. But this Power BI query works well for me by removing all the noise and getting relevant info into an easily digestible format that can be reviewed with stakeholders:

<pre><code>let
 MyJsonRecord = Json.Document(Web.Contents("https://api.github.com/repos/&lt;your org&gt;/&lt;your repo&gt;/issues?&amp;per_page=100&amp;page=1&amp;state=open&amp;filter=all", [Headers=[Authorization="Basic &lt;your auth token&gt;", Accept="application/vnd.github.symmetra-preview+json"]])),
 MyJsonTable = Table.FromRecords(MyJsonRecord),
 #"Column selection" = Table.SelectColumns(MyJsonTable,{"number", "title", "user", "labels", "state", "assignee", "assignees", "comments", "created_at", "updated_at", "closed_at", "body"}),
 #"Expanded labels" = Table.ExpandListColumn(#"Column selection", "labels"),
 #"Expanded labels1" = Table.ExpandRecordColumn(#"Expanded labels", "labels", {"name"}, {"labels.name"}),
 #"Grouped Rows" = Table.Group(#"Expanded labels1", {"number","title", "user", "state", "assignee", "assignees", "comments", "created_at", "updated_at", "closed_at", "body"}, {{"Label", each Text.Combine([labels.name],","), type text}}),
 #"Removed Other Columns" = Table.SelectColumns(#"Grouped Rows",{"number", "title", "state", "assignee", "comments", "created_at", "updated_at", "closed_at", "body", "Label"}),
 #"Expanded assignee" = Table.ExpandRecordColumn(#"Removed Other Columns", "assignee", {"login"}, {"assignee.login"})
in
 #"Expanded assignee"
</code></pre>

I added and then removed columns in this and did not clean this up - feel free to do that before you use it.
Obviously, you also have to fill in your own organization name and repo name into the URL, and obtain the auth token. I have tested the URL with a Chrome REST plugin and got the token from entering the user and api key there. You can authenticate explicitly from Excel with the user and key if you don't want to deal with the token. I just find it simpler to go the anonymous route in the query setup and instead provide the readily formatted request header.

Also, this works for repos with up to 100 open issues. If you have more, you need to duplicate the query (for page 2 etc) and combine the results.

Steps for using this query:

<ul>
<li>in a new sheet, on the "Data" tab, open the "Get Data" drop-down</li>
<li>select "Launch Power Query Editor"</li>
<li>in the editor, choose "New Query", "Other Sources", "Blank query"</li>
<li>now you click on "Advanced Editor" and paste the above query</li>
<li>click the "Done" button on the Advanced Editor, then "Close and Load" from the tool bar</li>
<li>the issues are loading in your spreadsheet and you are in business</li>
<li>no crappy third-party tool needed</li>
</ul>

entityMap|blocks|key|6hggv|text|导出拉取请求|type|unstyled|depth|inlineStyleRanges|entityRanges|data|99gbi|可以将问题导出到CSV文件，该文件可以使用Excel打开。它还支持GitLab和Bitbucket。|403tb|从它的文档中可以看到：|9g5r0|在sshaw/git-link和sshaw/itunes中导出打开的PR和问题|bqh7a|_|ed9bu|商店|a15ui|fg5ut|传输器：|cspfu|epr+sshaw/git-link+sshaw/itunes|a5njm|4i4l1|eohc5|5gq2s|传输器>+pr.csv|ckdi7|导出开放拉取请求不是由sshaw在padrino/padrino-framework中创建的：|e58p2|epr+-x+pr+-c+'!sshaw‘padrino/padrino-framework+>+pr.csv|ehirb|2lcco|它有几个用于过滤导出内容的选项。^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|13|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|14|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|15|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|16|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|17|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|18|9|@]|A|@]|B|$]]|$2|M|4|J|6|7|8|19|9|@]|A|@]|B|$]]|$2|N|4|O|6|7|8|1A|9|@]|A|@]|B|$]]|$2|P|4|Q|6|7|8|1B|9|@]|A|@]|B|$]]|$2|R|4|J|6|7|8|1C|9|@]|A|@]|B|$]]|$2|S|4|L|6|7|8|1D|9|@]|A|@]|B|$]]|$2|T|4|J|6|7|8|1E|9|@]|A|@]|B|$]]|$2|U|4|V|6|7|8|1F|9|@]|A|@]|B|$]]|$2|W|4|X|6|7|8|1G|9|@]|A|@]|B|$]]|$2|Y|4|Z|6|7|8|1H|9|@]|A|@]|B|$]]|$2|10|4|-4|6|7|8|1I|9|@]|A|@]|B|$]]|$2|11|4|12|6|7|8|1J|9|@]|A|@]|B|$]]]]

<a href="https://github.com/sshaw/export-pull-requests/" rel="nofollow noreferrer">Export Pull Requests</a> can export issues to a CSV file, which can be opened with Excel. It also supports GitLab and Bitbucket.
From its documentation:
<blockquote>
Export open PRs and issues in sshaw/git-link and
sshaw/itunes_store_transporter:
epr sshaw/git-link sshaw/itunes_store_transporter &gt; pr.csv
Export open pull request not created by sshaw in padrino/padrino-framework:
epr -x pr -c '!sshaw' padrino/padrino-framework &gt; pr.csv
</blockquote>
It has several options for filtering what gets exported.

entityMap|blocks|key|b1iva|text|可以使用Power+Query直接从Excel中查询GitHub的JSON+API。它确实需要一些关于如何将JSON转换成Excel表格格式的知识，但这是相当Googlable的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|16f3u|下面是如何首先获取数据的方法：|7q7j3|在Excel的Ribbon上，单击Data+>+Get+Data+>+From+JSON。在对话框中，输入API+URL...格式类似于(根据需要添加参数)：|8c1af|https://api.github.com/repos/|9s6ia|{所有者}/{回购}/issues|8e3um|将出现一个标记为"Access+Web+content“的对话框。|81qs8|在左侧，单击Basic选项卡。|8almu|在用户名文本框中，输入您的GitHub用户名。|4et3j|在密码文本框中，输入GitHub密码/个人访问令牌。|bhn8o|单击连接。|62eno|Power+Query+Editor将显示一个项目列表，其中显示Record。|3b0uv|..。现在搜索一下如何进行相应的转换，以便将适当的问题数据显示为单个表。^0|0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|Y|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|Z|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|10|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|11|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|12|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|13|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|14|9|@]|A|@]|B|$]]|$2|O|4|P|6|7|8|15|9|@]|A|@]|B|$]]|$2|Q|4|R|6|7|8|16|9|@]|A|@]|B|$]]|$2|S|4|T|6|7|8|17|9|@]|A|@]|B|$]]|$2|U|4|V|6|7|8|18|9|@]|A|@]|B|$]]|$2|W|4|X|6|7|8|19|9|@]|A|@]|B|$]]]]

GitHub's JSON API can be queried from directly in Excel using Power Query. It does require some knowledge about how to convert JSON into Excel table format but that's fairly Googlable. 

Here's how to first get to the data: 

<ul>
<li>In Excel, on Ribbon, click Data > Get Data > From JSON. In dialog
box, enter API URL ... in format similar to (add parms as you wish): 
<a href="https://api.github.com/repos/" rel="nofollow noreferrer">https://api.github.com/repos/</a>{owner}/{repo}/issues</li>
<li>A dialog box labeled "Access Web content" will appear.</li>
<li>On the left-hand side, click the Basic tab.</li>
<li>In the User name textbox, enter your GitHub username.</li>
<li>In the Password textbox, enter a GitHub password/Personal Access
token. </li>
<li>Click Connect.</li>
<li>Power Query Editor will be displayed with a list of items that say Record. </li>
</ul>

... now Google around for how to transform accordingly so that the appropriate issue data can be displayed as a single table.

entityMap|blocks|key|5md85|text|作为一次性任务，基于@Chip的基于“hub”的推荐……在已安装GitBash+prompt的windows系统上：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|42k9i|下载最新的中心可执行文件(如Windows+64位)|78eck|https://github.com/github/hub/releases/|817jd|并将其解压缩(hub.exe位于.../bin目录中)。|cgq68|创建github个人访问令牌|aei6e|https://github.com/settings/tokens|agikc|并将令牌文本字符串复制到剪贴板。|21loa|创建一个文本文件(例如在记事本中)以用作hub.exe的输入文件...第一行是您的github用户名，在第二行粘贴personal+access+token，然后是换行符(这样在向hub输入时，这两行都将被处理)。在这里，我假定文件是存储库的基目录中的infile.txt。|ccfep|运行Git+Bash..。并记住cd+(更改目录)到感兴趣的存储库！然后输入一行，如下所示：|60n9t|/bin/hub.exe+issue+-s+all+-f+"%25U%7C%25t%7C%25S%7C%25cI%7C%25uI%7C%25L%25n“<+infile.txt+>+outfile.csv|eam9j|然后使用'%7C‘作为列分隔符打开该文件。(并考虑删除github上的个人访问令牌)。^0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|W|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|X|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|Y|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|Z|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|10|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|11|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|12|9|@]|A|@]|B|$]]|$2|O|4|P|6|7|8|13|9|@]|A|@]|B|$]]|$2|Q|4|R|6|7|8|14|9|@]|A|@]|B|$]]|$2|S|4|T|6|7|8|15|9|@]|A|@]|B|$]]|$2|U|4|V|6|7|8|16|9|@]|A|@]|B|$]]]]

As a one-time task, building on 'hub'-based recommendation from @Chip... on a windows system with GitBash prompt already installed:
<ol>
<li>Download the latest hub executable (such as Windows 64 bit) <a href="https://github.com/github/hub/releases/" rel="nofollow noreferrer">https://github.com/github/hub/releases/</a> and extract it (hub.exe is in the .../bin directory).
</li>
<li>Create a github personal access token <a href="https://github.com/settings/tokens" rel="nofollow noreferrer">https://github.com/settings/tokens</a> and copy the token text string to the clipboard.
</li>
<li>Create a text file (such as in notepad) to use as the input file to hub.exe... the first line is your github user name and on the 2nd line paste the personal access token, followed by a newline (so that both lines will processed when input to hub). Here I presume the file is infile.txt in the repository's base directory.
</li>
<li>Run Git Bash... and remember to cd (change directory) to the repository of interest! Then enter a line like:
&lt;path_to_hub_folder&gt;/bin/hub.exe issue -s all -f &quot;%U|%t|%S|%cI|%uI|%L%n&quot; &lt; infile.txt &gt; outfile.csv
</li>
<li>Then open the file with '|' as the column delimiter. (and consider deleting the personal access token on github).
</li>
</ol>

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 (<a href="https://stackoverflow.com/questions/30133615/exporting-github-issues-to-csv">exporting Git issues to CSV</a> and getting "ImportError: No module named requests" errors. Is there any tool or any easy way to export all the issues to Excel?

How can I export GitHub issues to Excel?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

 如何将企业GitHub存储库中的所有问题导出到Excel文件？我尝试过搜索许多Stack Overflow答案，但没有成功。我也尝试过这个解决方案( 将Git问题导出到CSV 并收到"ImportError: No module named requests“错误。是否有任何工具或简单的方法可以将所有问题导出到Excel？

问如何将GitHub问题导出到Excel？
EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将GitHub问题导出到Excel？EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将GitHub问题导出到Excel？
EN