获得合并单元格的宽度在谷歌小号preadsheet API [英] Getting a merged cell width on Google Spreadsheet API
问题描述
我使用的是谷歌小号preadsheet API转换含工人轮班到事件日历文件。
唯一的问题是，变化是按照天数和小时（以天，小时，行和不同的工作插槽COLS），并重新通过合并单元格psented $ P $当我读到某个小区，这是合并，跨越6细胞，我不能让细胞一定宽度或它的合并范围。
I'm using the Google Spreadsheet API to convert a document containing workers shifts into event calendars. The only problem is that shifts are represented by merged cells according to days and hours (with days and hours as rows and different work slots as cols), and when I read a certain cell, which is merged and spans over 6 cells, I cannot get the cells certain width or its merged area.
例如：
For example:
如果我试图让之间的值（4C：4E）我会得到鲍勃说，而不是鲍勃，鲍勃，鲍勃，而我甚至不能找到一种方法来知道有多少细胞鲍勃服用。
If I try to get the values between (4C:4E) I will get "Bob, , ," and not "bob,bob,bob", and I cannot even find a way to know how many cells "bob" take.
难道你们知道我怎么能知道多少个单元合并一个S $ P $垫？或者说，至少是总宽度。
Do you guys know how can I know how many cells the merged one spread to? Or at least it's total width.
在此先感谢！
推荐答案
这不是通过s preadsheet API可能。我一直在寻找相同。谷歌承认其文档相同。
It's not possible via spreadsheet API. I was looking for same. Google admits the same in their documentation.
电池元件的字面值的计算值
电池，不带格式的应用。如果单元格中包含公式，
计算出的值在这里给出。在S preadsheets API没有概念
格式化，从而不能操纵细胞的格式。
The literal value of the cell element is the calculated value of the cell, without formatting applied. If the cell contains a formula, the calculated value is given here. The Spreadsheets API has no concept of formatting, and thus cannot manipulate formatting of cells.
相关问题：
<一href=\"http://stackoverflow.com/questions/2798514/set-cell-format-in-google-s$p$padsheet-using-python-api\">Set使用Python API 在谷歌小号preadsheet单元格的格式
Related question: Set cell format in google spreadsheet using python api
一个替代方法可以下载Excel格式的文档编程。它将包含格式信息。然后使用Excel API提取信息。
One alternate way can be to download the doc in excel format programmatically. It will contain formatting information. Then using excel API to extract the info.
这篇关于获得合并单元格的宽度在谷歌小号preadsheet API的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
