Best answeres tagged with excel

1

answer

Excel Converter Rows in Columns [closed]

asked by 15.08.2015 / 00:51

2

answers

SE function, SOMASE or what?

I'm trying to put together a formula, but I know less than the basics about Excel. I made a spreadsheet for sales control, and I put the cakes, sweet, savory, in columns and so far everything was going well, I used the SOMA function in the...

asked by 16.06.2016 / 21:55

0

answers

How to convert the tags of a .ris file into variables in a table?

I have a .ris file with data from researchers and would like to convert the labels of this files into variable column labels for excel.

asked by 07.04.2015 / 20:01

3

answers

Range in Excel VBA

I have the following code snippet: ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;C:\Users\Contoso\Desktop\ArquivosDoContoso.csv", Destination:=Range _ ("$A$1")) In the Destination:=Range _ ("$A$1")) part, how do I put the...

asked by 15.04.2015 / 13:38

0

answers

Access websites and extract contents to excel via VBA

Hello, I'm looking to learn how to tinker with websites and extract image values, or insert passwords and logins via VBA, but I do not know any of that. I would like to know if it is necessary to know HTML to do it, and if anyone knows some good...

asked by 01.07.2015 / 16:27

0

answers

Web Query on Site with Login

I need to access a site to do a web data import, but this site needs to login and whenever I leave the worksheet and enter again I have to edit the query and connect again! The idea was to make this connection automatically. Then I used a cod...

asked by 22.07.2015 / 05:51

2

answers

Problems with columns in Python XLRD

I'm a beginner in Python and am trying to make a script to sum all the values of an excel column and write the sum value in the worksheet. I'm using the Python xlrd and xlwt packages. The code works fine for the first column, but from the second...

asked by 08.08.2014 / 22:24

1

answer

Convert datatables in ASP.NET to different Excel SHEETS

How can I create more than sheets converting different datatable to excel? My code: DataTable dt = new DataTable(); dt = Tr.Get(); GridView x = new GridView(); x.DataSource = dt; x.DataBind();...

asked by 19.04.2014 / 15:25

2

answers

Update OLEDB Not working

Good afternoon, I'm trying to update an excel worksheet but the command is not changing any values, it's just corrupting the worksheet. I create the last two columns and rewrite the other connection.ConnectionString = "Provider=Microsoft.AC...

asked by 02.02.2018 / 18:12

2

answers

Date format in fraction

I have the following value 14/02/2018 13:53:12 in excel. Cell with the value is in text format. When you concatenate the value the date above looks like this: 43145,57861111111 Does anyone know how to solve it? The func...

asked by 15.02.2018 / 20:27

Questions tagged as 'excel'