<dd id="yld2g"><track id="yld2g"></track></dd>

    1. <th id="yld2g"></th>

      Questions tagged [excel]

      Only for questions on programming against Excel objects or files, or complex formula development. You may combine the Excel tag with VBA, VSTO, C#, VB.NET, PowerShell, OLE automation, and other programming related tags and questions if applicable. General help regarding MS Excel for single worksheet functions is available at Super User.

      Filter by
      Sorted by
      Tagged with
      0
      votes
      0answers
      9 views

      How do I reduce the time to Invoke Macro via Python?

      I noted that when I invoke a macro (via Python) to do some stuff in my Excel workbook it takes longer than if I write the code in Python to do it directly. The time difference is about 50% less. Is ...
      -1
      votes
      0answers
      11 views

      Corrigir Macro VBA envio de mensagem de texto/SMS

      Olá! Estou montando uma macro que faz envio de mensagem de texto usando o Messages.Google. Mas ele quando chega na parte Digite a Mensagem, ela n?o prossegue, e tambem n?o ponta nenhum erro. Alguém ...
      0
      votes
      0answers
      12 views

      How to access the Web using VBA? Please check my code

      In order to improve the repeatitive work, I tried to access the Web site which is using in company using VBA. So, I made code using VBA. And I checked it could be access the normal site such as google,...
      0
      votes
      0answers
      20 views

      how can get the formula of a data table in excell_

      this is my data and im trying to get the formula of it, how can i do it ( it dosent have to be using excell only but i dont know how to do it ) 0 2 4 6 8 0 100 90 80 ...
      0
      votes
      0answers
      21 views

      Worksheet copying dynamic cells

      I'm hoping to get some idea on automating copying some data in-between columns and worksheets. I have to clear column C, then copy B over, clear B then repeat for A. Where it gets tricky for me is ...
      0
      votes
      1answer
      25 views

      Ranges in Excel vs. in Google Sheets

      Let's take the following data: It seems that if you do =A2:A7 in Excel it will return a range whereas if you do the same in Google Sheets it will evaluate that to a SUM: What would be considered a ...
      0
      votes
      1answer
      19 views

      Python program does not write to an Excel cell

      First row is the header I then want cells to be printed. The code runs successfully. Creates the file and the header but does not print the values like Cars, 10 etc from row 2. What's wrong in the ...
      0
      votes
      0answers
      9 views

      Excel VBA - Downloaded csv file with url but it just displays html code instead of actual contents of csv file

      There is an online spreadsheet that has the option to "Download Spreadsheet". When you select it, it downloads the file as a .csv to the downloads folder. I want to download this spreadsheet ...
      0
      votes
      0answers
      6 views

      ASP NET Core is possible to read excel from bytes?

      i need to create a method in my API controller, where the user upload a excel file. After that i must read the excel and import some data to my database. I found this article that seems very good (i ...
      0
      votes
      2answers
      23 views

      Input Value on another table only when necessary

      I have another excel problem. What function do I need to display only a lead time when there is an order placed? For this example, the 3rd Lead Time RN "0.19" will be displayed on Week 7 of ...
      0
      votes
      0answers
      14 views

      Sorting a table by date in Excel, rows with the same date are not reversed as I expected? [duplicate]

      When sorting by the date I was surprised excel does not reverse the rows of data within the same dates. I have the following table of data: Date Narrative ...
      1
      vote
      4answers
      34 views

      Counting value based on 2 other column in excel

      How to count the value as shows in the below example in vba or excel formula, Count column should have a value of the combination of column1 and column2.
      0
      votes
      0answers
      10 views

      Use Sumproduct as Array Sumif

      I'm trying to build a lookup that adjust its array based on criteria for both row and column. Originally I was using sumif function that is using the correct arrays, however I found out that sumif is ...
      0
      votes
      2answers
      21 views

      VBA - Copy last Row Formula to New row (Table)

      looking for a code that will copy formula from Last Row to a new row in a table or some code that make the new row with formulas :) example: Last row number C25= A25+B25 so the new row Number 26 will ...
      1
      vote
      2answers
      27 views

      Copy just the value to new sheet in VBA

      I'm so close on this, but keep getting errors if I try to use .Value or .PasteSpecial xlPasteValue. I'm not sure where to put it, but I've tried multiple options. I want this to work as is, but just ...

      15 30 50 per page
      1
      2 3 4 5
      15885
      欧美日韩国产在线一区二区_午夜短视频在线观看_亚洲国产欧美日本视频_亚洲精品高清视频在线观看