Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature] Hope to provide API to directly obtain cell value through Excel column #3266

Open
2 tasks done
lyking90 opened this issue Aug 31, 2024 · 2 comments
Open
2 tasks done
Assignees
Labels
feature request New feature or request scope:facade

Comments

@lyking90
Copy link
Contributor

Initial checklist

  • Is this really a problem?
  • I have searched the Github Issues for similar issues, but did not find anything.

Problem

想要获取某个单元格比如A1的值,目前获取值的方式只能通过getRange,getValue,需要先创建range才能获取数据,很麻烦。

Solution

改进getRange的入参或者提供另外的univerApi,支持直接传入单个、多个单元格然后获取到数据

@lyking90 lyking90 added the feature request New feature or request label Aug 31, 2024
@univer-bot univer-bot bot changed the title [Feature] 希望提供通过Excel列直接获取cell value的Api [Feature] Hope to provide API to directly obtain cell value through Excel column Aug 31, 2024
@univer-bot
Copy link

univer-bot bot commented Aug 31, 2024

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

Origin Title: [Feature] 希望提供通过Excel列直接获取cell value的Api

Title: [Feature] Hope to provide API to directly obtain cell value through Excel column


Initial checklist

  • Is this really a problem?
  • I have searched the Github Issues for similar issues, but did not find anything.

Problem

If you want to get the value of a certain cell such as A1, the current way to get the value is through getRange and getValue. You need to create a range before you can get the data, which is very troublesome.

Solution

Improve the input parameters of getRange or provide another universalApi to support directly passing in single or multiple cells and then obtaining the data.

@hexf00
Copy link
Member

hexf00 commented Sep 2, 2024

@lyking90 The Range object not only retrieves cell values but also provides a rich set of APIs for manipulating cell content, formatting, and more, making it essential for interacting with spreadsheet data.

Thank you for your suggestion. We will consider your suggestion. If you have more specific suggestions, you are welcome to add them.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature request New feature or request scope:facade
Projects
None yet
Development

No branches or pull requests

4 participants
@hexf00 @lyking90 and others