excel tag

82 questions

1 answers
85 views
0

Ruby on Rails// Excel File Export Error// Axlsx Gem Please help me

Ruby on Rails// Excel File Export Error// Axlsx Gem Please help me if you have tried it If you run the ruby file itself, an Excel file is createdIf you run it inside the controller Uninitialized const...

ruby ruby-on-rails excel axlsx

2 years ago

1 answers
130 views
0

I wonder how to use the sheet in Python Excel

import openpyxllist = [X, Alpha, Beta, Gamma, B/A, C/A, C/B]initSet = ['0.1', '0.2', '0.3', '0.4','0.5','0.6','0.7','0.8','0.9']A = [0.3, 0.5, 0.7, 0.4, 0.2, 0.6, 0.4, 0.8, 0.2]B = [0.1, 0.3, 0.5, 0.7...

python3.7 excel openpyxl

2 years ago

1 answers
45 views
0

xlsxwriter readlines() feature

Does python xlsxwriter have a method that has the same function as Python's readlines()?I want to create a function in Excel that tries to erase a row if a particular cell in that row does not have a ...

xlsxwriter python excel

2 years ago

1 answers
105 views
0

If I enter the value of column a in Python Excel, is it possible for column B to come?

Is it possible to print 10,000 if I get input like the picture and type Choi in column A?I've been looking for this and that, but it doesn't come out that way.

python excel openpyxl

2 years ago

1 answers
112 views
0

Question about python openpyxl column.

This is a question about Excel in Python. import openpyxlwb = openpyxl.load_workbook('C:\\*/**.xlsx')ws = wb.activecol_A = ws['A']for col in col_A: print(col.value)This will output the entire column A...

python openpyxl excel column row

2 years ago

2 answers
35 views
0

Operation of Python graph output through Excel. Average growth rate, MIN, MAX

import numpy as npimport matplotlib.pyplot as plt! [Image][1]data = np.genfromtxt (cement production.csv,delimiter=',')print(data[3:,])x = data[3:,0]y = data[3:,0]for col in range(1,7): plt.plot(x,dat...

python excel

2 years ago

2 answers
39 views
0

Python, move Excel file

You have time series statistics.The time series statistics consist of a separate column of dates and data. The data movement we want to implement using Python is as above.This is the format in which a...

python excel

2 years ago

1 answers
42 views
0

Classify classification of class data in Excel

Hello, I'm posting my first question!Excelor students - Name of course - Subject classification like thisThe student is literally a,b,c,d...The major categories are AI, planning, marketing...It's divi...

python excel

2 years ago

1 answers
65 views
0

I want to ask questions about Panda's Excel!

There are worksheets called A and B There is no separate seat setting for both.A has written all the data that could come out of B in the first columnThe second column contains the values that you wan...

python pandas excel openpyxl xlsx

2 years ago

1 answers
44 views
0

Questions about Pandas

After using Pandas to load the accelerator,

python pandas excel

2 years ago

- 8 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656