René's URL Explorer Experiment


Title: string labels dumped to Excel should be formatted as strings · Issue #646 · larray-project/larray · GitHub

Open Graph Title: string labels dumped to Excel should be formatted as strings · Issue #646 · larray-project/larray

X Title: string labels dumped to Excel should be formatted as strings · Issue #646 · larray-project/larray

Description: >>> arr = ndtest('a=10E01,10E03') >>> arr.to_excel() produces something like: a | 1.00E+02 | 1.00E+04 | 0 | 1 This is not a visual transformation, it actually converts the values to numbers (whatever the actual dtype of labels were -- .d...

Open Graph Description: >>> arr = ndtest('a=10E01,10E03') >>> arr.to_excel() produces something like: a | 1.00E+02 | 1.00E+04 | 0 | 1 This is not a visual transformation, it actually converts the values to numbers (whatev...

X Description: >>> arr = ndtest('a=10E01,10E03') >>> arr.to_excel() produces something like: a | 1.00E+02 | 1.00E+04 | 0 | 1 This is not a visual transformation, it actually converts the...

Opengraph URL: https://github.com/larray-project/larray/issues/646

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"string labels dumped to Excel should be formatted as strings","articleBody":"```python\r\n>>> arr = ndtest('a=10E01,10E03')\r\n>>> arr.to_excel()\r\n```\r\nproduces something like:\r\n```\r\n a | 1.00E+02 | 1.00E+04\r\n   |        0 |        1\r\n```\r\nThis is not a visual transformation, it actually converts the values to numbers (whatever the actual dtype of labels were -- .dump() converts numpy types to raw Python types anyway)\r\n```python\r\n>>> arr.a.labels.dtype\r\ndtype('\u003cU5')\r\n>>> arr.dump()\r\n[['a', '10E01', '10E03'], ['', 0, 1]]\r\n```\r\nThe solution is to set NumberFormat on the target cells ***before*** pasting the values (https://github.com/ZoomerAnalytics/xlwings/issues/436).\r\n\r\n```python\r\n>>> wb = open_excel()\r\n>>> # produces bad result\r\n>>> wb[0]['A1'] = '10E03'\r\n>>> # produces good result\r\n>>> wb[0]['A2'].api.NumberFormat = \"@\"\r\n>>> wb[0]['A2'] = '10E03'\r\n```\r\n\r\nNote that set_labels (currently) returns object arrays. This should be irrelevant when we go via .dump(), which is always the case, I think (when using `wb[0] = array`, .dump() is called automatically).\r\n\r\n```python\r\n>>> ndtest(3).set_labels('a', {'a1': '10E03'}).a.labels.dtype\r\ndtype('O')\r\n```\r\n\r\nIdeally, this should be fixed in xlwings.\r\n\r\nHonestly, this issue seems easy to fix for small arrays (by scanning through each value and setting the format accordingly) but hard to do efficiently (set the format in chunks). Maybe .dump should not return a simple list of list but a custom object which retains the notion of axes etc. so that we can set the format for each axis in a single operation?","author":{"url":"https://github.com/gdementen","@type":"Person","name":"gdementen"},"datePublished":"2018-06-11T14:09:17Z","url":"https://github.com/larray-project/larray/issues/646"}

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:20f556d2-a4b2-39ca-7242-54addb627e92
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idAA3A:245A38:222B4A:2E78EA:6B00233F
html-safe-nonce4ad7496e5e2ed90f1c3db68a651fddca1ea8e3dc7e86c345127b4d40e4a23bc1
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBQTNBOjI0NUEzODoyMjJCNEE6MkU3OEVBOjZCMDAyMzNGIiwidmlzaXRvcl9pZCI6IjY1NzA5ODQzMDA3MzU0NTUzNSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac7c3cdf82245b1de55c8ba5bc657317a8c9f6f27a7075fff138ad280164f1c4b9
hovercard-subject-tagissue:331205445
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/larray-project/larray/646/issue_layout
twitter:imagehttps://opengraph.githubassets.com/ecb7e1d220dbb6c26824f7bacd73be7b8f5fd1949c3b0f1be275902bf48efffe/larray-project/larray/issues/646
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/ecb7e1d220dbb6c26824f7bacd73be7b8f5fd1949c3b0f1be275902bf48efffe/larray-project/larray/issues/646
og:image:alt>>> arr = ndtest('a=10E01,10E03') >>> arr.to_excel() produces something like: a | 1.00E+02 | 1.00E+04 | 0 | 1 This is not a visual transformation, it actually converts the values to numbers (whatev...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamegdementen
hostnamegithub.com
expected-hostnamegithub.com
None4eb4cba0d69f045374ac15de9666d22b0961e1d555cc3824f36b7734c00c78e0
turbo-cache-controlno-preview
go-importgithub.com/larray-project/larray git https://github.com/larray-project/larray.git
octolytics-dimension-user_id26460981
octolytics-dimension-user_loginlarray-project
octolytics-dimension-repository_id16981067
octolytics-dimension-repository_nwolarray-project/larray
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id16981067
octolytics-dimension-repository_network_root_nwolarray-project/larray
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release44c658b24abf00491fb7ae5f56d42c9f38cbeab2
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/larray-project/larray/issues/646#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Flarray-project%2Flarray%2Fissues%2F646
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Flarray-project%2Flarray%2Fissues%2F646
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=larray-project%2Flarray
Reloadhttps://github.com/larray-project/larray/issues/646
Reloadhttps://github.com/larray-project/larray/issues/646
Reloadhttps://github.com/larray-project/larray/issues/646
larray-projecthttps://github.com/larray-project
larrayhttps://github.com/larray-project/larray
Codehttps://github.com/larray-project/larray
Issues279 (279)https://github.com/larray-project/larray/issues
Pull requests6 (6)https://github.com/larray-project/larray/pulls
Actionshttps://github.com/larray-project/larray/actions
Security and qualityhttps://github.com/larray-project/larray/security
Insightshttps://github.com/larray-project/larray/insights
https://github.com/larray-project/larray
New issuehttps://github.com/login?return_to=https://github.com/larray-project/larray/issues/646
New issuehttps://github.com/login?return_to=https://github.com/larray-project/larray/issues/646
string labels dumped to Excel should be formatted as stringshttps://github.com/larray-project/larray/issues/646#top
bughttps://github.com/larray-project/larray/issues?q=state%3Aopen%20label%3A%22bug%22
component: excelhttps://github.com/larray-project/larray/issues?q=state%3Aopen%20label%3A%22component%3A%20excel%22
priority: highhttps://github.com/larray-project/larray/issues?q=state%3Aopen%20label%3A%22priority%3A%20high%22
0.37https://github.com/larray-project/larray/milestone/31
https://github.com/gdementen
gdementenhttps://github.com/gdementen
on Jun 11, 2018https://github.com/larray-project/larray/issues/646#issue-331205445
https://github.com/ZoomerAnalytics/xlwings/issues/436https://github.com/ZoomerAnalytics/xlwings/issues/436
gdementenhttps://github.com/gdementen
bughttps://github.com/larray-project/larray/issues?q=state%3Aopen%20label%3A%22bug%22
priority: highhttps://github.com/larray-project/larray/issues?q=state%3Aopen%20label%3A%22priority%3A%20high%22
component: excelhttps://github.com/larray-project/larray/issues?q=state%3Aopen%20label%3A%22component%3A%20excel%22
on Jun 11, 2018https://github.com/larray-project/larray/issues/646#event-1673979654
alixdammanhttps://github.com/alixdamman
0.29https://github.com/larray-project/larray/milestone/14
on Jun 11, 2018https://github.com/larray-project/larray/issues/646#event-1674083233
https://github.com/alixdamman
alixdammanhttps://github.com/alixdamman
on Jun 21, 2018https://github.com/larray-project/larray/issues/646#issuecomment-399029655
https://github.com/gdementen
gdementenhttps://github.com/gdementen
on Jun 21, 2018https://github.com/larray-project/larray/issues/646#issuecomment-399072760
alixdammanhttps://github.com/alixdamman
0.29https://github.com/larray-project/larray/milestone/14
0.30https://github.com/larray-project/larray/milestone/15
on Jun 26, 2018https://github.com/larray-project/larray/issues/646#event-1701568054
alixdammanhttps://github.com/alixdamman
0.30https://github.com/larray-project/larray/milestone/15
0.31https://github.com/larray-project/larray/milestone/18
on Jan 31, 2019https://github.com/larray-project/larray/issues/646#event-2109740435
gdementenhttps://github.com/gdementen
0.31https://github.com/larray-project/larray/milestone/18
on Aug 1, 2019https://github.com/larray-project/larray/issues/646#event-2526113115
alixdammanhttps://github.com/alixdamman
0.32https://github.com/larray-project/larray/milestone/19
on Aug 13, 2019https://github.com/larray-project/larray/issues/646#event-2553586624
https://github.com/alanmanning
alanmanninghttps://github.com/alanmanning
on Aug 22, 2019https://github.com/larray-project/larray/issues/646#issuecomment-524046336
https://github.com/gdementen
gdementenhttps://github.com/gdementen
on Aug 23, 2019https://github.com/larray-project/larray/issues/646#issuecomment-524213926
gdementenhttps://github.com/gdementen
0.32https://github.com/larray-project/larray/milestone/19
on Sep 24, 2019https://github.com/larray-project/larray/issues/646#event-2657251010
https://github.com/gdementen
gdementenhttps://github.com/gdementen
on Jan 5, 2021https://github.com/larray-project/larray/issues/646#issuecomment-754754184
gdementenhttps://github.com/gdementen
0.34https://github.com/larray-project/larray/milestone/24
on Jul 30, 2021https://github.com/larray-project/larray/issues/646#event-5092473789
gdementenhttps://github.com/gdementen
0.34https://github.com/larray-project/larray/milestone/24
0.35https://github.com/larray-project/larray/milestone/27
on Sep 13, 2022https://github.com/larray-project/larray/issues/646#event-7375607818
gdementenhttps://github.com/gdementen
0.35https://github.com/larray-project/larray/milestone/27
0.36https://github.com/larray-project/larray/milestone/28
on Sep 11, 2023https://github.com/larray-project/larray/issues/646#event-10331626078
gdementenhttps://github.com/gdementen
0.36https://github.com/larray-project/larray/milestone/28
0.37https://github.com/larray-project/larray/milestone/31
on Oct 6, 2025https://github.com/larray-project/larray/issues/646#event-20110441178
Sign up for freehttps://github.com/signup?return_to=https://github.com/larray-project/larray/issues/646
Sign in to commenthttps://github.com/login?return_to=https://github.com/larray-project/larray/issues/646
bughttps://github.com/larray-project/larray/issues?q=state%3Aopen%20label%3A%22bug%22
component: excelhttps://github.com/larray-project/larray/issues?q=state%3Aopen%20label%3A%22component%3A%20excel%22
priority: highhttps://github.com/larray-project/larray/issues?q=state%3Aopen%20label%3A%22priority%3A%20high%22
0.37No due datehttps://github.com/larray-project/larray/milestone/31
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.