Comments (6)
Hello, I have went though the code, but I don't see a way how to set a cell type when creating a new excel file. There isn't any setter for cell type, just getters.
from excel.
Hey @bakua , the reason for not giving the setter for cell-type is that, What happens if user sets the setter to int but has String type value in that cell, So when processing the excel file, It will be ambiguous and might lead to corrupted excel file.
So in line : https://github.com/kawal7415/excel/blob/0caf98033f5147f09b96f16270b1a15ce20ccf52/lib/src/sheet/sheet.dart#L877
You can see in the link to internal code that we have taken the load on us and give the users less headache to maintain things.
from excel.
We have headed to give the formula functionality so we had made the cell type dynamic which will help you to save your number as numeric.
You will be able to see the changes in the next version.
from excel.
Excel: ^1.0.9 is out https://pub.dev/packages/excel
CellType Functionality is available in order to save numeric cells
Now excel being more faster
than before.
Added Functionalities:
Cell Type
Copy Sheet
Rename Sheet
Delete Sheet
Link Sheets
Un-Link Sheets
Font Family (182 Font Family Available)
Font Size
Italic
Underline
Bold
Thank You
Long Live Open S🔥urce
from excel.
If you set the value to an int then it automatically sets the type to CellType.int
from excel.
I see, that's pretty cool. Thanks for explanation :) Might be worth to mention in docs that cells are auto typed.
from excel.
Related Issues (20)
- Help: Determining the type of a cell HOT 1
- How to use custom Chinese fonts
- Excel - Roadmap Tasks HOT 2
- Default constructors for simplicity
- rename sheet breaks with archive 3.4.10 HOT 1
- Excel.decodeBytes -> Bad State too many elements
- The argument type 'String' can't be assigned to the parameter type 'ExcelColor' HOT 4
- How to parse Excel cell merging information?
- Bug reading SpannedItems as empty HOT 2
- README.md demo doesn't compile since 4.0.3 update
- Couldn't decode ".xls" file HOT 1
- Cannot delete sheets HOT 6
- DateTimeCellValue not working on Windows
- Very inefficient RAM usage HOT 2
- Can't read the XLSX file from http request - Damaged Excel file: Corrupted Excel file HOT 1
- How to save .csv
- Bad state: No element while parsing
- Can I select the sheet I want to open in a file that has multiple sheets?
- update package HOT 5
- Cells with a time below `02:25:00` are recognized as `DateTimeCellValue` HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from excel.