Aspose 单元格数字格式与处理后的数据源
我是 Aspose Cells 的新手，继承了一个使用它的项目。添加了一项要求，即单元格中的数值必须是实际数字 - 它们以前是文本。
因此，我更改了调用 Cell.PutValue() 的代码中的调用，以使用采用 bool isConverted 的方法的重载版本。在该参数中传递“true”值解决了这些实例的问题。
但是，在代码的其他位置，我们使用 ExcelDesigner.SetDataSource() 和 ExcelDesigner.Process() 将网站中的数据导出到电子表格中。通过这种方法生成的电子表格还将数字作为文本存储在单元格中。
在这种情况下，如何将文本转换为数字，就像我在 PutValue() 情况下所做的那样？
I am new to Aspose Cells, having inherited a project that uses it. A requirement was added that numeric values in cells be actual numbers - they were formerly text.
So, I changed calls in the code that called Cell.PutValue() to use the overloaded version of the method that takes the bool isConverted. Passing a value of "true" in that parameter solved the problem for these instances.
However, in other places in the code, we export data from our website into a spreadsheet by using ExcelDesigner.SetDataSource() and ExcelDesigner.Process(). The spreadsheets resulting from this approach also have numbers stored in cells as text.
How can I convert the text to numbers in this case, as I did with the PutValue() case?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
事实证明，Aspose 使用了一种名为“
智能标记具有可选的“参数”，它们是带括号、逗号分隔的修饰符，提供进一步的处理指令。 “（数字）”指令实现了我正在寻找的结果。
It turns out that Aspose uses something called "Smart Markers", which are directives embedded into the cells of template spreadsheets that Aspose Cells uses to decide how data should be inserted into them.
Smart Markers have optional "parameters", which are parenthesized, comma-separated modifiers giving further processing instructions. The "(numeric)" directive achieved the result that I was looking for.
您也可以直接在 Aspose.Cells 中发布查询论坛，以防您需要任何进一步的帮助。因为这些论坛由我们的支持和开发团队监控。
披露：我在 Aspose 担任开发人员传播者。
You may also post a query directly in Aspose.Cells forums, in case you need any further assistance. As those forums are monitored by our support and development teams.
Disclosure: I work as developer evangelist at Aspose.