首页 \ 问答 \ VBA做直到循环或“”条件(VBA Do Until Loop with Or “” condition)

VBA做直到循环或“”条件(VBA Do Until Loop with Or “” condition)

 Do Until Sheets("Sheet1").Cells(x, y).Value = stringOne Or ""

        x = x + 1

 Loop
 
 在上面的VBA代码片中，我得到一个运行时错误“13”：类型不匹配。 stringOne被声明为一个String。 我可以消除或“”和循环的作品。 我可以消除stringOne，只有“”和循环工作。 只有当我添加Or“”时，循环才会停止运作。 我甚至换了订单，即，=“”或stringOne。 有什么想法吗？ 

 Do Until Sheets("Sheet1").Cells(x, y).Value = stringOne Or ""

        x = x + 1

 Loop
 
In the above VBA code slice, I get a Run-time error '13': Type mismatch. stringOne is declared a String. I can eliminate Or "" and the loop works. I can eliminate stringOne and only have "" and the loop works. Only when I add the Or "" does the loop stop functioning. I've even swapped order, i.e, = "" Or stringOne. Any thoughts?

原文：https://stackoverflow.com/questions/24633133

更新时间：2022-09-26 11:09

最满意答案

 我认为您可以使用参数squeeze转换为Series主要：  
import pandas as pd
from pandas.compat import StringIO

temp=u"""2000-01-03,111.937502
2000-01-04,102.500003
2000-01-05,103.999997
2000-01-06,94.999998
2000-01-07,99.500001"""
#after testing replace 'StringIO(temp)' to 'filename.csv'
aapl = pd.read_csv(StringIO(temp), 
                   squeeze=True, 
                   index_col=[0], 
                   parse_dates=True, 
                   names=['Date','col'])

print(type(aapl))
<class 'pandas.core.series.Series'>

print(type(aapl.index))
<class 'pandas.core.indexes.datetimes.DatetimeIndex'>

print(aapl.head())
Date
2000-01-03    111.937502
2000-01-04    102.500003
2000-01-05    103.999997
2000-01-06     94.999998
2000-01-07     99.500001
Name: col, dtype: float64

I think you can use parameter squeeze for convert to Series mainly: 
import pandas as pd
from pandas.compat import StringIO

temp=u"""2000-01-03,111.937502
2000-01-04,102.500003
2000-01-05,103.999997
2000-01-06,94.999998
2000-01-07,99.500001"""
#after testing replace 'StringIO(temp)' to 'filename.csv'
aapl = pd.read_csv(StringIO(temp), 
                   squeeze=True, 
                   index_col=[0], 
                   parse_dates=True, 
                   names=['Date','col'])

print(type(aapl))
<class 'pandas.core.series.Series'>

print(type(aapl.index))
<class 'pandas.core.indexes.datetimes.DatetimeIndex'>

print(aapl.head())
Date
2000-01-03    111.937502
2000-01-04    102.500003
2000-01-05    103.999997
2000-01-06     94.999998
2000-01-07     99.500001
Name: col, dtype: float64

VBA做直到循环或“”条件(VBA Do Until Loop with Or “” condition)

最满意答案

相关问答

TCP/IP模型是一个________。[2023-10-02]

下列中不属于面向对象的编程语言的是?[2022-05-30]

使用Python在Pandas中读取CSV文件时的UnicodeDecodeError(UnicodeDecodeError when reading CSV file in Pandas with Python)[2023-05-01]

Python Pandas - 从csv文件创建时间序列(Python Pandas - Creating a timeseries from a csv file)[2022-08-18]

Python Pandas比较CSV keyerror(Python Pandas compare CSV keyerror)[2022-08-04]

Pandas TimeSeries进入MongoDB(Pandas TimeSeries into MongoDB)[2022-09-13]

在python中使用pandas加载.csv文件时出错(Errors when loading .csv file using pandas in python)[2022-05-07]

使用Python / Pandas将JSON导出为CSV(Export JSON to CSV using Python/Pandas)[2023-11-06]

使用csv或pandas模块将python csv转换为字典(python csv to dictionary using csv or pandas module)[2023-05-26]

使用pandas将csv文件中的数据读入时间序列(Reading data from csv file into time series with pandas)[2023-08-25]

相关文章

最新问答