python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - xlsx

trouble with utf-8 with julia and jupyterlab

I'm reading the csv file at https://github.com/VinitaSilaparasetty/julia-beginners/blob/master/data/nba/nba19-20.csv I get a DataFrame and I save it as XLSX. When I try to read it in jupyterlab I get ...
test-img

Enzo

dataframe

utf-8

julia

xlsx

jupyter-lab

Votes: 0

Answers: 1

Latest Answer

Do you have the jupyterlab-spreadsheet plugin installed? JupyterLab by default doesn't support opening xlsx files (it isn't mentioned in the file formats list here for example). See also this similar ...
test-img

Sundar R

Keeping leading 0s when at using read.csv()

I am trying to create a tool that reads multiple CSVs from a folder and converts them into xlsx. My problem is that in some variables there are leading zeros that I want to keep. But the variable name...
test-img

Adrian Mnc

r

csv

format

xlsx

Votes: 0

Answers: 2

Latest Answer

I'd do this in multiple steps: First, I'd read in the table with everything as character: df <- read.table(file, sep=',', colClasses='character') df a b c 1 1 01 3 2 2 10 043 3 3 30 43 4 4...
test-img

divibisan

SheetJs converting string with date automatically to date angular

I am importing a CSV file in my angular application using sheetjs, Data is imported successfully. but it is converting string with a date to only date ignoring the string. Code in ts file readExcel(...
test-img

user202

node.js

angular

typescript

xlsx

sheetjs

Votes: 0

Answers: 0

Extracting data from Excel XML files using perl XML::Twig handlers when tags (nodes) contain prefix

I use XML::Twig handlers/roots to extract information from large XML files where it costs too much to load the entire file into memory. These XML files are the internal sheet files of Excel .xlsx file...
test-img

Chazg76

xml

perl

xlsx

xml-twig

Votes: 0

Answers: 1

Latest Answer

OK, I've found a solution. Turns out that XML::Twig has an optional argument map_xmlns I can use this to fix my problem. So, my original code my $t= XML::Twig->new(twig_roots => {'worksheet/she...
test-img

Chazg76

Posts

Questions

Blogs

Jobs