Grabbing data from excel using power shell (More specific) The Next CEO of Stack OverflowHow to recursively delete an entire directory with PowerShell 2.0?How to have an excel addin read rows from a worksheet until no more data?How to count the number of rows in excel with data?Read Excel data with Powershell and write to a variableExcel: VLOOKUP from a different SheetHow to find a cell with any value and then find the next value that is different in VBAReading from Excel gives ####### in some columnsCopy values from specific cells in rows to a column in MS ExcelExcel looping from column A and finding matches with corresponding values and moving them to a new worksheetUsing (Nested Loop) .find to grab identical values seperate sheets VBA EXCEL
Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis
What flight has the highest ratio of time difference to flight time?
What steps are necessary to read a Modern SSD in Medieval Europe?
Legal workarounds for testamentary trust perceived as unfair
Can we say or write : "No, it'sn't"?
How to avoid supervisors with prejudiced views?
Rotate a column
Can MTA send mail via a relay without being told so?
Is it professional to write unrelated content in an almost-empty email?
When you upcast Blindness/Deafness, do all targets suffer the same effect?
Writing differences on a blackboard
Is it possible to replace duplicates of a character with one character using tr
"misplaced omit" error when >centering columns
Won the lottery - how do I keep the money?
Proper way to express "He disappeared them"
Why, when going from special to general relativity, do we just replace partial derivatives with covariant derivatives?
What was the first Unix version to run on a microcomputer?
Can you be charged for obstruction for refusing to answer questions?
Help understanding this unsettling image of Titan, Epimetheus, and Saturn's rings?
Is the D&D universe the same as the Forgotten Realms universe?
Is it possible to use a NPN BJT as switch, from single power source?
Bartok - Syncopation (1): Meaning of notes in between Grand Staff
Why do airplanes bank sharply to the right after air-to-air refueling?
Some questions about different axiomatic systems for neighbourhoods
Grabbing data from excel using power shell (More specific)
The Next CEO of Stack OverflowHow to recursively delete an entire directory with PowerShell 2.0?How to have an excel addin read rows from a worksheet until no more data?How to count the number of rows in excel with data?Read Excel data with Powershell and write to a variableExcel: VLOOKUP from a different SheetHow to find a cell with any value and then find the next value that is different in VBAReading from Excel gives ####### in some columnsCopy values from specific cells in rows to a column in MS ExcelExcel looping from column A and finding matches with corresponding values and moving them to a new worksheetUsing (Nested Loop) .find to grab identical values seperate sheets VBA EXCEL
I want to grab the data from a cell based on another cell. They would be in the same row, separate columns. I want to grab that value using PowerShell.
An example would be
Want to be able to in my code based on a cell in column A find its corresponding column B value. I know how to get cell info but not based on another cell. Any help would be much appreciated!!
excel powershell
edited Mar 21 at 19:58
LotPings
20.1k61633
asked Mar 21 at 18:01
A. GilA. Gil
1
add a comment |
I want to grab the data from a cell based on another cell. They would be in the same row, separate columns. I want to grab that value using PowerShell.
An example would be
Want to be able to in my code based on a cell in column A find its corresponding column B value. I know how to get cell info but not based on another cell. Any help would be much appreciated!!
excel powershell
edited Mar 21 at 19:58
LotPings
20.1k61633
asked Mar 21 at 18:01
A. GilA. Gil
1
2
Could you please provide more details about your code? What have your tried so far? What worked, and what issues are you trying to solve in your code?
– kgrg
Mar 21 at 18:10
add a comment |
I want to grab the data from a cell based on another cell. They would be in the same row, separate columns. I want to grab that value using PowerShell.
An example would be
Want to be able to in my code based on a cell in column A find its corresponding column B value. I know how to get cell info but not based on another cell. Any help would be much appreciated!!
excel powershell
edited Mar 21 at 19:58
LotPings
20.1k61633
asked Mar 21 at 18:01
A. GilA. Gil
1
I want to grab the data from a cell based on another cell. They would be in the same row, separate columns. I want to grab that value using PowerShell.
An example would be
Want to be able to in my code based on a cell in column A find its corresponding column B value. I know how to get cell info but not based on another cell. Any help would be much appreciated!!
excel powershell
excel powershell
edited Mar 21 at 19:58
LotPings
20.1k61633
asked Mar 21 at 18:01
A. GilA. Gil
1
edited Mar 21 at 19:58
LotPings
20.1k61633
asked Mar 21 at 18:01
A. GilA. Gil
1
edited Mar 21 at 19:58
LotPings
20.1k61633
edited Mar 21 at 19:58
LotPings
20.1k61633
edited Mar 21 at 19:58
LotPings
20.1k61633
20.1k61633
asked Mar 21 at 18:01
A. GilA. Gil
1
asked Mar 21 at 18:01
A. GilA. Gil
1
asked Mar 21 at 18:01
A. GilA. Gil
1
1
2
Could you please provide more details about your code? What have your tried so far? What worked, and what issues are you trying to solve in your code?
– kgrg
Mar 21 at 18:10
add a comment |
2
Could you please provide more details about your code? What have your tried so far? What worked, and what issues are you trying to solve in your code?
– kgrg
Mar 21 at 18:10
2
2
Could you please provide more details about your code? What have your tried so far? What worked, and what issues are you trying to solve in your code?
– kgrg
Mar 21 at 18:10
Could you please provide more details about your code? What have your tried so far? What worked, and what issues are you trying to solve in your code?
– kgrg
Mar 21 at 18:10
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55286612%2fgrabbing-data-from-excel-using-power-shell-more-specific%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55286612%2fgrabbing-data-from-excel-using-power-shell-more-specific%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Could you please provide more details about your code? What have your tried so far? What worked, and what issues are you trying to solve in your code?
– kgrg
Mar 21 at 18:10