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

Read files from google sheets #1

Closed
dimkaone opened this issue Jul 11, 2018 · 6 comments
Closed

Read files from google sheets #1

dimkaone opened this issue Jul 11, 2018 · 6 comments

Comments

@dimkaone
Copy link

If I export a file from Google Sheets, only the first column is read in this file.

@plandem
Copy link
Owner

plandem commented Jul 11, 2018

can you provide that file?

@dimkaone
Copy link
Author

test _xlsx.xlsx

@plandem
Copy link
Owner

plandem commented Jul 11, 2018

Ok, there were few bugs with iteration and one was related to your file. I fixed and added tests, now it must work as supposed.

@plandem
Copy link
Owner

plandem commented Jul 11, 2018

I close this issue, because tests are passing now. If you will have any issue, then just write here and i will reopen

@plandem plandem closed this as completed Jul 11, 2018
@dimkaone
Copy link
Author

Thanks for the quick help))

@plandem
Copy link
Owner

plandem commented Jul 12, 2018

I also added iterators to simplify process of iterating:

	for rows := sheet.Rows(); rows.HasNext(); {
		_, row := rows.Next()
		
		for cells := row.Cells(); cells.HasNext(); {
			iCol, iRow, cell := cells.Next()
			if iRow % 2 == 0 && iCol % 2 == 0 {
				cell.SetFormatting(redBoldYellow)
			}
		}
	}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants