The Wayback Machine - https://web.archive.org/web/20191024212659/https://github.com/topics/spreadsheet
Skip to content
#

spreadsheet

Here are 488 public repositories matching this topic...

js-xlsx
KurtMar
KurtMar commented Sep 12, 2019

I noticed a bug in the html_to_sheet function. When reading cells that are empty, the cell index is correctly incremented, but if the cell has HTML tags and is observed to be empty after stripping the tags, the cell index is not incremented. This results in misalignment of the subsequent cells:

https://github.com/SheetJS/js-xlsx/blob/e3c5eac99c3b2be6929adfca455c1be87fab792b/xlsx.js#L18956-L18

spandanmadan
spandanmadan commented Sep 13, 2015

I'm getting this error when I'm trying to open a spreadsheet. Can someone help me with this?

raise HTTPError("%s: %s" % (response.status, response.read()))
gspread.exceptions.HTTPError: 401:

<TITLE>Token invalid - AuthSub token has wrong scope</TITLE>

Token invalid - AuthSub token has wrong scope

Error 401

leefionglee
leefionglee commented Aug 7, 2016

The length of list is too large to be displayed and no error shows. The demo code is showed as below:

import xlsxwriter

workbook = xlsxwriter.Workbook('Example_Error.xlsx')  # where to write
worksheet = workbook.add_worksheet('Test')
red = workbook.add_format({'color': 'red'})
blue = workbook.add_format({'color': 'blue'})

string_a = ['I ', 'like ', 'this ', red, 'apple ', 'and ', 'th
padma295
padma295 commented Feb 24, 2018

Dear Team,

First of all, thanks a lot for this API. It is saving a lot of time when I try to pull out data from a Google Spreadsheet or update data.

I would like to know if it is possible to detect the format of a particular cell range/row/cell when reading from gsheet. Is it possible to read only the Bold font items or exclude strike-through items or read only a particular coloured rows usi

z-skywalker
z-skywalker commented Aug 15, 2019

If I have two xlnt::border objects defined with the same sides except the diagonal direction, for example:

xlnt::border down_, up_;
// set the sides of down_ and up_ with the same value
// ...
down_.diagonal(xlnt::diagonal_direction::down);
up_.diagonal(xlnt::diagonal_direction::up);

Then I applied them to different cells:

ws.cell("A1").border(down_);
ws.cell("A2").border(
You can’t perform that action at this time.