• Register

Recent questions tagged excel

0 votes
1 answer 12 views
Problem I am developing some application using PHP, HTML and JavaScript. Now I am developing a feature, which will expose to user a download button, upon clicking it, server executes MySql query (I am using MySql as data base) and from data base response a file report is ... : “Hey, this is CSV you can open it with Excel!”. Tried to use “echo” it did not help a lot.
asked Dec 4, 2020 alexh 2.2k points
1 vote
1 answer 7 views
0 votes
1 answer 11 views
How do you convert a numerical number to an Excel column name in C# without using automation getting the value directly from Excel.?
asked Aug 28, 2020 Aliza313 720 points
0 votes
1 answer 15 views
Problem: Currently I am trying to get my excel to copy every row which says either apple, berry or cherry for a previous month and then put them in my corresponding sheets. I have also tried some of the VBA code but I am also having a lot of trouble while making ... to search all of my sheet names rather than just the "apple". Also I am experiencing trouble while finding a last row with my data.
asked Aug 6, 2020 Raphael Pacheco 4.9k points
1 vote
2 answers 1.1K views
Problem : I am very new to VBA. Recently I was using VBA code to execute the solver. On executing my VBA code I am facing below error. Integer constraint cell reference must include only variable cells . I wanted my cells C87:K93 as integers but somehow my constraints ... ="0"    SolverOk SetCell:="$N$95", MaxMinVal:=1, ValueOf:="0", ByChange:="$C$87:$K$93"    SolverSolve UserFinish:=True End Sub
asked May 9, 2020 stewart 4k points
0 votes
2 answers 79 views
Problem: An Excel ____ allows data to be summarized and charted easily?
asked Apr 12, 2020 ArifulIslam 5.6k points
0 votes
2 answers 63 views
Problem: Can anyone give the right solution by filling in the blanks? A database is used instead of a spreadsheet when ________? A) lists of data involve a single theme B) structures of data lists are simple C) lists involve data with multiple themes D) users do not want to store all data in one place
asked Feb 23, 2020 maddi86 5.4k points
0 votes
1 answer 28 views
Problem: Does anybody realize how to rename a segment in google spreadsheets?
asked Feb 21, 2020 jennygotit 200 points
0 votes
1 answer 73 views
Problem : We have a few Windows Desktop Apps written in VB.2010 and VB.2017 that have been running for quite a while at numerous clients. At that point a week ago Tues, Nov 13, 2018 we began getting clients messages and considers saying the applications are getting a mistake 1004/ ... are real. I am certain this is a MS bug. Would someone be able to point me the correct way and ideally a MS fix?
asked Nov 29, 2019 alecxe 7.5k points
0 votes
1 answer 221 views
Problem : I am having the following error whenever I am trying to open Excel Online in Chrome, But Excel Online in Safari is working fine for me. Does anyone know how to fix this issue? Sign in Something went wrong and we can't sign you in ... . Please try again later. The Microsoft account login server has detected too many repeated authentication attempts. Please wait a moment and try again.
asked Nov 26, 2019 alecxe 7.5k points
0 votes
2 answers 240 views
Problem : Facing following C# selenium webdriver error while reading Excel Sheet. missing compiler required member 'microsoft.csharp.runtimebinder.csharpargumentinfo.create' And the code for reading excel is as below: excel.Application x1Appl = new excel.Application(); excel. ... \o\SearchBy.xlsx"); excel._Worksheet x1WorkSheet = x1WorkBook.Sheets[1]; Kindly let me know is there anything missing?
asked Nov 18, 2019 peterlaw 6.9k points
0 votes
1 answer 104 views
Problem : Need solution for bellow problem the cell reference for the merged cell is the upper-right cell reference.
asked Nov 7, 2019 peterlaw 6.9k points
To see more, click for the full list of questions or popular tags.